1SET @start_global_value = @@global.innodb_spin_wait_delay; 2SELECT @start_global_value; 3@start_global_value 44 5Valid values are zero or above 6select @@global.innodb_spin_wait_delay >=0; 7@@global.innodb_spin_wait_delay >=0 81 9select @@global.innodb_spin_wait_delay; 10@@global.innodb_spin_wait_delay 114 12select @@session.innodb_spin_wait_delay; 13ERROR HY000: Variable 'innodb_spin_wait_delay' is a GLOBAL variable 14show global variables like 'innodb_spin_wait_delay'; 15Variable_name Value 16innodb_spin_wait_delay 4 17show session variables like 'innodb_spin_wait_delay'; 18Variable_name Value 19innodb_spin_wait_delay 4 20select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_SPIN_WAIT_DELAY 4 23select * from information_schema.session_variables where variable_name='innodb_spin_wait_delay'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_SPIN_WAIT_DELAY 4 26set global innodb_spin_wait_delay=10; 27select @@global.innodb_spin_wait_delay; 28@@global.innodb_spin_wait_delay 2910 30select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_SPIN_WAIT_DELAY 10 33select * from information_schema.session_variables where variable_name='innodb_spin_wait_delay'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_SPIN_WAIT_DELAY 10 36set session innodb_spin_wait_delay=1; 37ERROR HY000: Variable 'innodb_spin_wait_delay' is a GLOBAL variable and should be set with SET GLOBAL 38set global innodb_spin_wait_delay=DEFAULT; 39select @@global.innodb_spin_wait_delay; 40@@global.innodb_spin_wait_delay 414 42set global innodb_spin_wait_delay=0; 43select @@global.innodb_spin_wait_delay; 44@@global.innodb_spin_wait_delay 450 46set global innodb_spin_wait_delay=5000; 47select @@global.innodb_spin_wait_delay; 48@@global.innodb_spin_wait_delay 495000 50set global innodb_spin_wait_delay=65535; 51Warnings: 52Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '65535' 53select @@global.innodb_spin_wait_delay; 54@@global.innodb_spin_wait_delay 556000 56set global innodb_spin_wait_delay=4294967295; 57Warnings: 58Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '4294967295' 59select @@global.innodb_spin_wait_delay; 60@@global.innodb_spin_wait_delay 616000 62set @@global.innodb_spin_wait_delay = 4294967296; 63Warnings: 64Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '4294967296' 65select @@global.innodb_spin_wait_delay; 66@@global.innodb_spin_wait_delay 676000 68set @@global.innodb_spin_wait_delay = 12345678901; 69Warnings: 70Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '12345678901' 71select @@global.innodb_spin_wait_delay; 72@@global.innodb_spin_wait_delay 736000 74set @@global.innodb_spin_wait_delay = 18446744073709551615; 75Warnings: 76Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '18446744073709551615' 77select @@global.innodb_spin_wait_delay; 78@@global.innodb_spin_wait_delay 796000 80set global innodb_spin_wait_delay=1.1; 81ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 82set global innodb_spin_wait_delay=1e1; 83ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 84set global innodb_spin_wait_delay="foo"; 85ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 86set global innodb_spin_wait_delay=' '; 87ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 88select @@global.innodb_spin_wait_delay; 89@@global.innodb_spin_wait_delay 906000 91set global innodb_spin_wait_delay=" "; 92ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 93select @@global.innodb_spin_wait_delay; 94@@global.innodb_spin_wait_delay 956000 96set global innodb_spin_wait_delay=-7; 97Warnings: 98Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '-7' 99select @@global.innodb_spin_wait_delay; 100@@global.innodb_spin_wait_delay 1010 102set global innodb_spin_wait_delay=-1024; 103Warnings: 104Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '-1024' 105select @@global.innodb_spin_wait_delay; 106@@global.innodb_spin_wait_delay 1070 108select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay'; 109VARIABLE_NAME VARIABLE_VALUE 110INNODB_SPIN_WAIT_DELAY 0 111SET @@global.innodb_spin_wait_delay = @start_global_value; 112SELECT @@global.innodb_spin_wait_delay; 113@@global.innodb_spin_wait_delay 1144 115