Bug #100120 innodb_doublewrite_batch_size is marked as a Global Dynamic variable

• Submitted: 6 Jul 2020 9:14
• Modified: 7 Jul 2020 13:12
• Reporter: Mohit Joshi
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0.20
• OS: Any
• CPU Architecture: Any

[6 Jul 2020 9:14] Mohit Joshi

Description:
As per docs: https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_doublewrite_b...

The variable is marked as a Global dynamic variable. However, when tried to set from the MySQL client, it return an error

mysql> select version();
+--------------+
| version()    |
+--------------+
| 8.0.20-debug |
+--------------+
1 row in set (0.00 sec)

mysql> set global innodb_doublewrite_batch_size=10;
ERROR 1238 (HY000): Variable 'innodb_doublewrite_batch_size' is a read only variable

This looks like a documentation bug or if the variable is supposed to be dynamic in nature, then please fix it.

How to repeat:
mysql> set global innodb_doublewrite_batch_size=10;
ERROR 1238 (HY000): Variable 'innodb_doublewrite_batch_size' is a read only variable

[6 Jul 2020 9:29] MySQL Verification Team

Thank you for the bug report.

[7 Jul 2020 13:12] Daniel Price

Posted by developer:
 
The documentation was revised as suggested. Changes should appear online soon.

Thank you for the bug report.