1SET @start_value = @@GLOBAL.innodb_empty_free_list_algorithm; 2SELECT @@GLOBAL.innodb_empty_free_list_algorithm; 3@@GLOBAL.innodb_empty_free_list_algorithm 4backoff 5SELECT @@SESSION.innodb_empty_free_list_algorithm; 6ERROR HY000: Variable 'innodb_empty_free_list_algorithm' is a GLOBAL variable 7SET GLOBAL innodb_empty_free_list_algorithm='legacy'; 8SELECT @@GLOBAL.innodb_empty_free_list_algorithm; 9@@GLOBAL.innodb_empty_free_list_algorithm 10legacy 11SET GLOBAL innodb_empty_free_list_algorithm='backoff'; 12SELECT @@GLOBAL.innodb_empty_free_list_algorithm; 13@@GLOBAL.innodb_empty_free_list_algorithm 14backoff 15SET GLOBAL innodb_empty_free_list_algorithm=1.1; 16ERROR 42000: Incorrect argument type to variable 'innodb_empty_free_list_algorithm' 17SET GLOBAL innodb_empty_free_list_algorithm=1e1; 18ERROR 42000: Incorrect argument type to variable 'innodb_empty_free_list_algorithm' 19SET GLOBAL innodb_empty_free_list_algorithm=2; 20ERROR 42000: Variable 'innodb_empty_free_list_algorithm' can't be set to the value of '2' 21SET GLOBAL innodb_empty_free_list_algorithm='foo'; 22ERROR 42000: Variable 'innodb_empty_free_list_algorithm' can't be set to the value of 'foo' 23SET GLOBAL innodb_empty_free_list_algorithm = @start_value; 24