1SET @start_global_value = @@global.innodb_old_blocks_time; 2SELECT @start_global_value; 3@start_global_value 41000 5Valid values are zero or above 6select @@global.innodb_old_blocks_time >=0; 7@@global.innodb_old_blocks_time >=0 81 9select @@global.innodb_old_blocks_time; 10@@global.innodb_old_blocks_time 111000 12select @@session.innodb_old_blocks_time; 13ERROR HY000: Variable 'innodb_old_blocks_time' is a GLOBAL variable 14show global variables like 'innodb_old_blocks_time'; 15Variable_name Value 16innodb_old_blocks_time 1000 17show session variables like 'innodb_old_blocks_time'; 18Variable_name Value 19innodb_old_blocks_time 1000 20select * from information_schema.global_variables where variable_name='innodb_old_blocks_time'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_OLD_BLOCKS_TIME 1000 23select * from information_schema.session_variables where variable_name='innodb_old_blocks_time'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_OLD_BLOCKS_TIME 1000 26set global innodb_old_blocks_time=10; 27select @@global.innodb_old_blocks_time; 28@@global.innodb_old_blocks_time 2910 30select * from information_schema.global_variables where variable_name='innodb_old_blocks_time'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_OLD_BLOCKS_TIME 10 33select * from information_schema.session_variables where variable_name='innodb_old_blocks_time'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_OLD_BLOCKS_TIME 10 36set session innodb_old_blocks_time=1; 37ERROR HY000: Variable 'innodb_old_blocks_time' is a GLOBAL variable and should be set with SET GLOBAL 38set global innodb_old_blocks_time=1.1; 39ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_time' 40set global innodb_old_blocks_time=1e1; 41ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_time' 42set global innodb_old_blocks_time="foo"; 43ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_time' 44set global innodb_old_blocks_time=-7; 45Warnings: 46Warning 1292 Truncated incorrect innodb_old_blocks_time value: '-7' 47select @@global.innodb_old_blocks_time; 48@@global.innodb_old_blocks_time 490 50select * from information_schema.global_variables where variable_name='innodb_old_blocks_time'; 51VARIABLE_NAME VARIABLE_VALUE 52INNODB_OLD_BLOCKS_TIME 0 53SET @@global.innodb_old_blocks_time = @start_global_value; 54SELECT @@global.innodb_old_blocks_time; 55@@global.innodb_old_blocks_time 561000 57