1SET @start_value = @@GLOBAL.innodb_cleaner_eviction_factor;
2SELECT @@GLOBAL.innodb_cleaner_eviction_factor;
3@@GLOBAL.innodb_cleaner_eviction_factor
40
5SELECT @@SESSION.innodb_cleaner_eviction_factor;
6ERROR HY000: Variable 'innodb_cleaner_eviction_factor' is a GLOBAL variable
7SET GLOBAL innodb_cleaner_eviction_factor='OFF';
8SELECT @@GLOBAL.innodb_cleaner_eviction_factor;
9@@GLOBAL.innodb_cleaner_eviction_factor
100
11SET GLOBAL innodb_cleaner_eviction_factor='ON';
12SELECT @@GLOBAL.innodb_cleaner_eviction_factor;
13@@GLOBAL.innodb_cleaner_eviction_factor
141
15SET GLOBAL innodb_cleaner_eviction_factor=0;
16SELECT @@GLOBAL.innodb_cleaner_eviction_factor;
17@@GLOBAL.innodb_cleaner_eviction_factor
180
19SET GLOBAL innodb_cleaner_eviction_factor=1;
20SELECT @@GLOBAL.innodb_cleaner_eviction_factor;
21@@GLOBAL.innodb_cleaner_eviction_factor
221
23SET GLOBAL innodb_cleaner_eviction_factor=1.1;
24ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_eviction_factor'
25SET GLOBAL innodb_cleaner_eviction_factor=1e1;
26ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_eviction_factor'
27SET GLOBAL innodb_cleaner_eviction_factor=2;
28ERROR 42000: Variable 'innodb_cleaner_eviction_factor' can't be set to the value of '2'
29SET GLOBAL innodb_cleaner_eviction_factor='foo';
30ERROR 42000: Variable 'innodb_cleaner_eviction_factor' can't be set to the value of 'foo'
31SET GLOBAL innodb_cleaner_eviction_factor = @start_value;
32