Bug #71875 innodb_old_blocks_time documentation is inconsistent.
Submitted: 28 Feb 2014 8:24 Modified: 4 Mar 2014 14:29
Reporter: Simon Mudd (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6.15 OS:Any
Assigned to: Daniel Price CPU Architecture:Any
Tags: innodb_old_blocks_time

[28 Feb 2014 8:24] Simon Mudd
Description:
http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html#innodb-performance-midpoint... mentions:

"The default value of innodb_old_blocks_time is 0, corresponding to the original behavior of moving a page to the most-recently used end of the buffer pool list when it is first accessed in the buffer pool."

Yet, http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_old_blocks_tim... says for this variable:

The default value is 1000 as of MySQL 5.6.6, 0 before that.

So I'm assuming the documentation in the first URL is incorrect and needs correcting.

How to repeat:
see above.

Suggested fix:
Adjust the documentation to be consistent with the current settings.

Not a big deal but if you're looking at optimising settings then it's good to be clear about what current defaults are, and if they have changed.
[28 Feb 2014 11:52] MySQL Verification Team
Thank you for the bug report.
[4 Mar 2014 14:29] Daniel Price
Thank you for the bug report. The 5.6 and 5.7 reference manual has been updated to address this issue. The change should appear soon, with the next published documentation build.