MySQL Bugs: #66979: innodb_purge_batch

Bug #66979	innodb_purge_batch_size is Dynamic
Submitted:	27 Sep 2012 3:52	Modified:	10 Apr 2013 1:55
Reporter:	Jervin R	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.5	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
Doc says innodb_purge_batch_size is not dynamic, but in fact it is:

http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_purge_batch_si...

How to repeat:
[revin@forge ~]$ sb 5525
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.25a MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql [localhost] {msandbox} ((none)) > select @@global.innodb_purge_batch_size;
+----------------------------------+
| @@global.innodb_purge_batch_size |
+----------------------------------+
|                               20 |
+----------------------------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} ((none)) > set global innodb_purge_batch_size=2000;
Query OK, 0 rows affected (0.00 sec)

mysql [localhost] {msandbox} ((none)) > select @@global.innodb_purge_batch_size;
+----------------------------------+
| @@global.innodb_purge_batch_size |
+----------------------------------+
|                             2000 |
+----------------------------------+
1 row in set (0.00 sec)

Thank you for the bug report.

d:\dbs>d:\dbs\5.5\bin\mysql -uroot --port=3541 --prompt="mysql 5.5 >"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 30
Server version: 5.5.29 Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.5 >select @@global.innodb_purge_batch_size;
+----------------------------------+
| @@global.innodb_purge_batch_size |
+----------------------------------+
|                               20 |
+----------------------------------+
1 row in set (0.02 sec)

mysql 5.5 >set global innodb_purge_batch_size=2000;
Query OK, 0 rows affected (0.02 sec)

mysql 5.5 >select @@global.innodb_purge_batch_size;
+----------------------------------+
| @@global.innodb_purge_batch_size |
+----------------------------------+
|                             2000 |
+----------------------------------+
1 row in set (0.00 sec)

mysql 5.5 >

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.