Bug #68671 innodb_thread_sleep_delay documentation

• Submitted: 14 Mar 2013 10:17
• Modified: 23 May 2013 17:27
• Reporter: Holger Haag
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6.10
• OS: Any
• Assigned to: Bugs System
• CPU Architecture: Any

[14 Mar 2013 10:17] Holger Haag

Description:
5.6 automatically adjusts innodb_thread_sleep_delay, so the values after startup may change and be different from what is in the my.cnf file.

This is a great feature and well documented under

http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html

but the documentation on the system variable itself doesn't mention the new feature

http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_thread_sleep_d...

I think the sysvar documentation should cross-reference the other doc in order to avoid confusion (I was wondering where innodb_thread_sleep_delay values come from after playing around with 5.6).

How to repeat:
Start 5.6.10 mysqld with different my.cnf values for innodb_thread_sleep_delay and compare to output from

show variables like '%innodb_thread_sleep_delay%';

Suggested fix:
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_thread_sleep_d...

should cross-reference

http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html

[14 Mar 2013 15:36] MySQL Verification Team

Verified as described ....

[23 May 2013 17:27] Bugs System

Revised description of "innodb_thread_sleep_delay" variable in the 5.6 and 5.7 reference manuals. The revised content will appear shortly. 

Thank you for the bug report.