1SET @start_global_value = @@global.innodb_change_buffering; 2SELECT @start_global_value; 3@start_global_value 4all 5Valid values are 'all', 'deletes', 'changes', 'inserts', 'none', 'purges' 6select @@global.innodb_change_buffering in ('all', 'deletes', 'changes', 'inserts', 'none', 'purges'); 7@@global.innodb_change_buffering in ('all', 'deletes', 'changes', 'inserts', 'none', 'purges') 81 9select @@global.innodb_change_buffering; 10@@global.innodb_change_buffering 11all 12select @@session.innodb_change_buffering; 13ERROR HY000: Variable 'innodb_change_buffering' is a GLOBAL variable 14show global variables like 'innodb_change_buffering'; 15Variable_name Value 16innodb_change_buffering all 17show session variables like 'innodb_change_buffering'; 18Variable_name Value 19innodb_change_buffering all 20select * from information_schema.global_variables where variable_name='innodb_change_buffering'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_CHANGE_BUFFERING all 23select * from information_schema.session_variables where variable_name='innodb_change_buffering'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_CHANGE_BUFFERING all 26set global innodb_change_buffering='none'; 27select @@global.innodb_change_buffering; 28@@global.innodb_change_buffering 29none 30select * from information_schema.global_variables where variable_name='innodb_change_buffering'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_CHANGE_BUFFERING none 33select * from information_schema.session_variables where variable_name='innodb_change_buffering'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_CHANGE_BUFFERING none 36set @@global.innodb_change_buffering='inserts'; 37select @@global.innodb_change_buffering; 38@@global.innodb_change_buffering 39inserts 40select * from information_schema.global_variables where variable_name='innodb_change_buffering'; 41VARIABLE_NAME VARIABLE_VALUE 42INNODB_CHANGE_BUFFERING inserts 43select * from information_schema.session_variables where variable_name='innodb_change_buffering'; 44VARIABLE_NAME VARIABLE_VALUE 45INNODB_CHANGE_BUFFERING inserts 46set session innodb_change_buffering='some'; 47ERROR HY000: Variable 'innodb_change_buffering' is a GLOBAL variable and should be set with SET GLOBAL 48set @@session.innodb_change_buffering='some'; 49ERROR HY000: Variable 'innodb_change_buffering' is a GLOBAL variable and should be set with SET GLOBAL 50set global innodb_change_buffering=1.1; 51ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering' 52set global innodb_change_buffering=1; 53SELECT @@global.innodb_change_buffering; 54@@global.innodb_change_buffering 55inserts 56set global innodb_change_buffering=-2; 57ERROR 42000: Variable 'innodb_change_buffering' can't be set to the value of '-2' 58set global innodb_change_buffering=1e1; 59ERROR 42000: Incorrect argument type to variable 'innodb_change_buffering' 60set global innodb_change_buffering='some'; 61ERROR 42000: Variable 'innodb_change_buffering' can't be set to the value of 'some' 62SET @@global.innodb_change_buffering = @start_global_value; 63SELECT @@global.innodb_change_buffering; 64@@global.innodb_change_buffering 65all 66