1SET @start_global_value = @@global.innodb_spin_wait_delay; 2SELECT @start_global_value; 3@start_global_value 46 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 116 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 6 17show session variables like 'innodb_spin_wait_delay'; 18Variable_name Value 19innodb_spin_wait_delay 6 20select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_SPIN_WAIT_DELAY 6 23select * from information_schema.session_variables where variable_name='innodb_spin_wait_delay'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_SPIN_WAIT_DELAY 6 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=1.1; 39ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 40set global innodb_spin_wait_delay=1e1; 41ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 42set global innodb_spin_wait_delay="foo"; 43ERROR 42000: Incorrect argument type to variable 'innodb_spin_wait_delay' 44set global innodb_spin_wait_delay=-7; 45Warnings: 46Warning 1292 Truncated incorrect innodb_spin_wait_delay value: '-7' 47select @@global.innodb_spin_wait_delay; 48@@global.innodb_spin_wait_delay 490 50select * from information_schema.global_variables where variable_name='innodb_spin_wait_delay'; 51VARIABLE_NAME VARIABLE_VALUE 52INNODB_SPIN_WAIT_DELAY 0 53SET @@global.innodb_spin_wait_delay = @start_global_value; 54SELECT @@global.innodb_spin_wait_delay; 55@@global.innodb_spin_wait_delay 566 57