1SET @start_global_value = @@global.flush_time; 2select @@global.flush_time; 3@@global.flush_time 40 5select @@session.flush_time; 6ERROR HY000: Variable 'flush_time' is a GLOBAL variable 7show global variables like 'flush_time'; 8Variable_name Value 9flush_time 0 10show session variables like 'flush_time'; 11Variable_name Value 12flush_time 0 13select * from information_schema.global_variables where variable_name='flush_time'; 14VARIABLE_NAME VARIABLE_VALUE 15FLUSH_TIME 0 16select * from information_schema.session_variables where variable_name='flush_time'; 17VARIABLE_NAME VARIABLE_VALUE 18FLUSH_TIME 0 19set global flush_time=1; 20select @@global.flush_time; 21@@global.flush_time 221 23set session flush_time=1; 24ERROR HY000: Variable 'flush_time' is a GLOBAL variable and should be set with SET GLOBAL 25SET global flush_time = DEFAULT; 26SELECT @@global.flush_time; 27@@global.flush_time 280 29SET @@global.flush_time = -1024; 30Warnings: 31Warning 1292 Truncated incorrect flush_time value: '-1024' 32SELECT @@global.flush_time; 33@@global.flush_time 340 35set global flush_time=1.1; 36ERROR 42000: Incorrect argument type to variable 'flush_time' 37set global flush_time=1e1; 38ERROR 42000: Incorrect argument type to variable 'flush_time' 39set global flush_time="foo"; 40ERROR 42000: Incorrect argument type to variable 'flush_time' 41set global flush_time=" "; 42ERROR 42000: Incorrect argument type to variable 'flush_time' 43set global flush_time=0; 44select @@global.flush_time; 45@@global.flush_time 460 47set global flush_time=cast(-1 as unsigned int); 48Warnings: 49Warning 1292 Truncated incorrect flush_time value: '18446744073709551615' 50select @@global.flush_time; 51@@global.flush_time 5231536000 53SET @@global.flush_time = @start_global_value; 54