1SET @start_value = @@GLOBAL.innodb_cleaner_free_list_lwm; 2SELECT @@GLOBAL.innodb_cleaner_free_list_lwm; 3@@GLOBAL.innodb_cleaner_free_list_lwm 410 5SELECT @@SESSION.innodb_cleaner_free_list_lwm; 6ERROR HY000: Variable 'innodb_cleaner_free_list_lwm' is a GLOBAL variable 7SET GLOBAL innodb_cleaner_free_list_lwm=0; 8SELECT @@GLOBAL.innodb_cleaner_free_list_lwm; 9@@GLOBAL.innodb_cleaner_free_list_lwm 100 11SET GLOBAL innodb_cleaner_free_list_lwm=1; 12SELECT @@GLOBAL.innodb_cleaner_free_list_lwm; 13@@GLOBAL.innodb_cleaner_free_list_lwm 141 15SET GLOBAL innodb_cleaner_free_list_lwm=99; 16SELECT @@GLOBAL.innodb_cleaner_free_list_lwm; 17@@GLOBAL.innodb_cleaner_free_list_lwm 1899 19SET GLOBAL innodb_cleaner_free_list_lwm=100; 20SELECT @@GLOBAL.innodb_cleaner_free_list_lwm; 21@@GLOBAL.innodb_cleaner_free_list_lwm 22100 23SET GLOBAL innodb_cleaner_free_list_lwm=101; 24Warnings: 25Warning 1292 Truncated incorrect innodb_cleaner_free_list_lwm value: '101' 26SELECT @@innodb_cleaner_free_list_lwm; 27@@innodb_cleaner_free_list_lwm 28100 29SET GLOBAL innodb_cleaner_free_list_lwm=1.1; 30ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_free_list_lwm' 31SET GLOBAL innodb_cleaner_free_list_lwm=1e1; 32ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_free_list_lwm' 33SET GLOBAL innodb_cleaner_free_list_lwm='foo'; 34ERROR 42000: Incorrect argument type to variable 'innodb_cleaner_free_list_lwm' 35SET GLOBAL innodb_cleaner_free_list_lwm = @start_value; 36