1SET @start_global_value = @@global.innodb_old_blocks_pct; 2SELECT @start_global_value; 3@start_global_value 437 5Valid values are between 5 and 95 6select @@global.innodb_old_blocks_pct between 5 and 95; 7@@global.innodb_old_blocks_pct between 5 and 95 81 9select @@global.innodb_old_blocks_pct; 10@@global.innodb_old_blocks_pct 1137 12select @@session.innodb_old_blocks_pct; 13ERROR HY000: Variable 'innodb_old_blocks_pct' is a GLOBAL variable 14show global variables like 'innodb_old_blocks_pct'; 15Variable_name Value 16innodb_old_blocks_pct 37 17show session variables like 'innodb_old_blocks_pct'; 18Variable_name Value 19innodb_old_blocks_pct 37 20select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_OLD_BLOCKS_PCT 37 23select * from information_schema.session_variables where variable_name='innodb_old_blocks_pct'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_OLD_BLOCKS_PCT 37 26set global innodb_old_blocks_pct=10; 27select @@global.innodb_old_blocks_pct; 28@@global.innodb_old_blocks_pct 2910 30select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_OLD_BLOCKS_PCT 10 33select * from information_schema.session_variables where variable_name='innodb_old_blocks_pct'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_OLD_BLOCKS_PCT 10 36set session innodb_old_blocks_pct=1; 37ERROR HY000: Variable 'innodb_old_blocks_pct' is a GLOBAL variable and should be set with SET GLOBAL 38set @@global.innodb_old_blocks_pct=DEFAULT; 39select @@global.innodb_old_blocks_pct; 40@@global.innodb_old_blocks_pct 4137 42set global innodb_old_blocks_pct=1.1; 43ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct' 44set global innodb_old_blocks_pct=1e1; 45ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct' 46set global innodb_old_blocks_pct="foo"; 47ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct' 48set global innodb_old_blocks_pct=" "; 49ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct' 50set global innodb_old_blocks_pct=''; 51ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct' 52set global innodb_old_blocks_pct=4; 53Warnings: 54Warning 1292 Truncated incorrect innodb_old_blocks_pct value: '4' 55select @@global.innodb_old_blocks_pct; 56@@global.innodb_old_blocks_pct 575 58select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct'; 59VARIABLE_NAME VARIABLE_VALUE 60INNODB_OLD_BLOCKS_PCT 5 61set global innodb_old_blocks_pct=-7; 62Warnings: 63Warning 1292 Truncated incorrect innodb_old_blocks_pct value: '-7' 64select @@global.innodb_old_blocks_pct; 65@@global.innodb_old_blocks_pct 665 67select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct'; 68VARIABLE_NAME VARIABLE_VALUE 69INNODB_OLD_BLOCKS_PCT 5 70set global innodb_old_blocks_pct=96; 71Warnings: 72Warning 1292 Truncated incorrect innodb_old_blocks_pct value: '96' 73select @@global.innodb_old_blocks_pct; 74@@global.innodb_old_blocks_pct 7595 76select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct'; 77VARIABLE_NAME VARIABLE_VALUE 78INNODB_OLD_BLOCKS_PCT 95 79set global innodb_old_blocks_pct=5; 80select @@global.innodb_old_blocks_pct; 81@@global.innodb_old_blocks_pct 825 83set global innodb_old_blocks_pct=95; 84select @@global.innodb_old_blocks_pct; 85@@global.innodb_old_blocks_pct 8695 87SET @@global.innodb_old_blocks_pct = @start_global_value; 88SELECT @@global.innodb_old_blocks_pct; 89@@global.innodb_old_blocks_pct 9037 91