1SET @start_value = @@GLOBAL.innodb_cleaner_max_flush_time;
2SELECT @@GLOBAL.innodb_cleaner_max_flush_time;
3@@GLOBAL.innodb_cleaner_max_flush_time
41000
5SELECT @@SESSION.innodb_cleaner_max_flush_time;
6ERROR HY000: Variable 'innodb_cleaner_max_flush_time' is a GLOBAL variable
7SET GLOBAL innodb_cleaner_max_flush_time=0;
8SELECT @@GLOBAL.innodb_cleaner_max_flush_time;
9@@GLOBAL.innodb_cleaner_max_flush_time
100
11SET GLOBAL innodb_cleaner_max_flush_time=1000;
12SELECT @@GLOBAL.innodb_cleaner_max_flush_time;
13@@GLOBAL.innodb_cleaner_max_flush_time
141000
15SET GLOBAL innodb_cleaner_max_flush_time=4294967295;
16SELECT @@GLOBAL.innodb_cleaner_max_flush_time;
17@@GLOBAL.innodb_cleaner_max_flush_time
184294967295
19SET GLOBAL innodb_cleaner_max_flush_time=1.1;
20ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_flush_time'
21SET GLOBAL innodb_cleaner_max_flush_time=1e1;
22ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_flush_time'
23SET GLOBAL innodb_cleaner_max_flush_time='foo';
24ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_max_flush_time'
25SET GLOBAL innodb_cleaner_max_flush_time = @start_value;
26