SET @start_value = @@GLOBAL.innodb_cleaner_max_lru_time;
SELECT @@GLOBAL.innodb_cleaner_max_lru_time;
@@GLOBAL.innodb_cleaner_max_lru_time
1000
SELECT @@SESSION.innodb_cleaner_max_lru_time;
ERROR HY000: Variable 'innodb_cleaner_max_lru_time' is a GLOBAL variable
SET GLOBAL innodb_cleaner_max_lru_time=0;
SELECT @@GLOBAL.innodb_cleaner_max_lru_time;
@@GLOBAL.innodb_cleaner_max_lru_time
0
SET GLOBAL innodb_cleaner_max_lru_time=1000;
SELECT @@GLOBAL.innodb_cleaner_max_lru_time;
@@GLOBAL.innodb_cleaner_max_lru_time
1000
SET GLOBAL innodb_cleaner_max_lru_time=4294967295;
SELECT @@GLOBAL.innodb_cleaner_max_lru_time;
@@GLOBAL.innodb_cleaner_max_lru_time
4294967295
SET GLOBAL innodb_cleaner_max_lru_time=1.1;
ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_lru_time'
SET GLOBAL innodb_cleaner_max_lru_time=1e1;
ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_lru_time'
SET GLOBAL innodb_cleaner_max_lru_time='foo';
ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_lru_time'
SET GLOBAL innodb_cleaner_max_lru_time = @start_value;
