1SET @start_global_value = @@global.innodb_thread_sleep_delay; 2SELECT @start_global_value; 3@start_global_value 410000 5Valid values are zero or above 6select @@global.innodb_thread_sleep_delay >=0; 7@@global.innodb_thread_sleep_delay >=0 81 9select @@global.innodb_thread_sleep_delay; 10@@global.innodb_thread_sleep_delay 1110000 12select @@session.innodb_thread_sleep_delay; 13ERROR HY000: Variable 'innodb_thread_sleep_delay' is a GLOBAL variable 14show global variables like 'innodb_thread_sleep_delay'; 15Variable_name Value 16innodb_thread_sleep_delay 10000 17show session variables like 'innodb_thread_sleep_delay'; 18Variable_name Value 19innodb_thread_sleep_delay 10000 20select * from information_schema.global_variables where variable_name='innodb_thread_sleep_delay'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_THREAD_SLEEP_DELAY 10000 23select * from information_schema.session_variables where variable_name='innodb_thread_sleep_delay'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_THREAD_SLEEP_DELAY 10000 26set global innodb_thread_sleep_delay=10; 27select @@global.innodb_thread_sleep_delay; 28@@global.innodb_thread_sleep_delay 2910 30select * from information_schema.global_variables where variable_name='innodb_thread_sleep_delay'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_THREAD_SLEEP_DELAY 10 33select * from information_schema.session_variables where variable_name='innodb_thread_sleep_delay'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_THREAD_SLEEP_DELAY 10 36set session innodb_thread_sleep_delay=1; 37ERROR HY000: Variable 'innodb_thread_sleep_delay' is a GLOBAL variable and should be set with SET GLOBAL 38set global innodb_thread_sleep_delay=1.1; 39ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay' 40set global innodb_thread_sleep_delay=1e1; 41ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay' 42set global innodb_thread_sleep_delay="foo"; 43ERROR 42000: Incorrect argument type to variable 'innodb_thread_sleep_delay' 44set global innodb_thread_sleep_delay=18446744073709551616; 45Warnings: 46Warning 1916 Got overflow when converting '18446744073709551616' to INT. Value truncated 47Warning 1292 Truncated incorrect innodb_thread_sleep_delay value: '9223372036854775807' 48set global innodb_thread_sleep_delay=-7; 49Warnings: 50Warning 1292 Truncated incorrect innodb_thread_sleep_delay value: '-7' 51select @@global.innodb_thread_sleep_delay; 52@@global.innodb_thread_sleep_delay 530 54select * from information_schema.global_variables where variable_name='innodb_thread_sleep_delay'; 55VARIABLE_NAME VARIABLE_VALUE 56INNODB_THREAD_SLEEP_DELAY 0 57set global innodb_thread_sleep_delay=0; 58select @@global.innodb_thread_sleep_delay; 59@@global.innodb_thread_sleep_delay 600 61set global innodb_thread_sleep_delay=1000; 62select @@global.innodb_thread_sleep_delay; 63@@global.innodb_thread_sleep_delay 641000 65set global innodb_thread_sleep_delay=1000000; 66select @@global.innodb_thread_sleep_delay; 67@@global.innodb_thread_sleep_delay 681000000 69set global innodb_thread_sleep_delay=1000001; 70Warnings: 71Warning 1292 Truncated incorrect innodb_thread_sleep_delay value: '1000001' 72select @@global.innodb_thread_sleep_delay; 73@@global.innodb_thread_sleep_delay 741000000 75set global innodb_thread_sleep_delay=4294967295; 76Warnings: 77Warning 1292 Truncated incorrect innodb_thread_sleep_delay value: '4294967295' 78select @@global.innodb_thread_sleep_delay; 79@@global.innodb_thread_sleep_delay 801000000 81set global innodb_thread_sleep_delay=555; 82select @@global.innodb_thread_sleep_delay; 83@@global.innodb_thread_sleep_delay 84555 85SET @@global.innodb_thread_sleep_delay = @start_global_value; 86SELECT @@global.innodb_thread_sleep_delay; 87@@global.innodb_thread_sleep_delay 8810000 89