Bug #71430 Manual does not describe range of possible values for innodb_thread_sleep_delay
Submitted: 20 Jan 2014 16:46 Modified: 22 Jan 2014 13:40
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: Daniel Price CPU Architecture:Any
Tags: innodb_thread_sleep_delay

[20 Jan 2014 16:46] Valeriy Kravchuk 
Description:
Manual (http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_thread_sleep_d...) does not described range of possible values for innodb_thread_sleep_delay

How to repeat:
mysql> set global innodb_thread_sleep_delay=2*1024*1024*1024;
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like 'innodb_thread_sleep%';
+---------------------------+------------+
| Variable_name             | Value      |
+---------------------------+------------+
| innodb_thread_sleep_delay | 2147483648 |
+---------------------------+------------+
1 row in set (0.00 sec)

mysql> set global innodb_thread_sleep_delay=4*1024*1024*1024;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1292
Message: Truncated incorrect innodb_thread_sleep_delay value: '4294967296'
1 row in set (0.00 sec)

mysql> show global variables like 'innodb_thread_sleep%';
+---------------------------+------------+
| Variable_name             | Value      |
+---------------------------+------------+
| innodb_thread_sleep_delay | 4294967295 |
+---------------------------+------------+
1 row in set (0.00 sec)

Try to find explanation of the above in the manual.

Suggested fix:
Document the range that looks like 0..4294967295
[20 Jan 2014 18:20] MySQL Verification Team 
Hello Valeriy,

Thank you for the bug report.

Thanks,
Umesh
[22 Jan 2014 13:39] Daniel Price 
Posted by developer:
 
The innodb_thread_sleep_delay documentation has been updated for 5.1 through 5.6. 
The minimum value is 0 and the max value is either 1<<64 - 1 or 1<<32 -1 microseconds.

The documentation update will appear soon, with the next published documentation build.
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_thread_sleep_d...

Thank you for the bug report.