1SET @start_global_value = @@global.binlog_skip_flush_commands; 2SELECT @start_global_value; 3@start_global_value 40 5SELECT @@global.binlog_skip_flush_commands IN (0, 1); 6@@global.binlog_skip_flush_commands IN (0, 1) 71 8SELECT @@global.binlog_skip_flush_commands; 9@@global.binlog_skip_flush_commands 100 11SELECT @@session.binlog_skip_flush_commands; 12ERROR HY000: Variable 'binlog_skip_flush_commands' is a GLOBAL variable 13SHOW GLOBAL VARIABLES LIKE 'binlog_skip_flush_commands'; 14Variable_name Value 15binlog_skip_flush_commands OFF 16SHOW SESSION VARIABLES LIKE 'binlog_skip_flush_commands'; 17Variable_name Value 18binlog_skip_flush_commands OFF 19SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 20VARIABLE_NAME VARIABLE_VALUE 21BINLOG_SKIP_FLUSH_COMMANDS OFF 22SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 23VARIABLE_NAME VARIABLE_VALUE 24BINLOG_SKIP_FLUSH_COMMANDS OFF 25SET GLOBAL binlog_skip_flush_commands = ON; 26SELECT @@global.binlog_skip_flush_commands; 27@@global.binlog_skip_flush_commands 281 29SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 30VARIABLE_NAME VARIABLE_VALUE 31BINLOG_SKIP_FLUSH_COMMANDS ON 32SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 33VARIABLE_NAME VARIABLE_VALUE 34BINLOG_SKIP_FLUSH_COMMANDS ON 35SET GLOBAL binlog_skip_flush_commands = OFF; 36SELECT @@global.binlog_skip_flush_commands; 37@@global.binlog_skip_flush_commands 380 39SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 40VARIABLE_NAME VARIABLE_VALUE 41BINLOG_SKIP_FLUSH_COMMANDS OFF 42SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 43VARIABLE_NAME VARIABLE_VALUE 44BINLOG_SKIP_FLUSH_COMMANDS OFF 45SET GLOBAL binlog_skip_flush_commands = 'ON'; 46SELECT @@global.binlog_skip_flush_commands; 47@@global.binlog_skip_flush_commands 481 49SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 50VARIABLE_NAME VARIABLE_VALUE 51BINLOG_SKIP_FLUSH_COMMANDS ON 52SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 53VARIABLE_NAME VARIABLE_VALUE 54BINLOG_SKIP_FLUSH_COMMANDS ON 55SET GLOBAL binlog_skip_flush_commands = 'OFF'; 56SELECT @@global.binlog_skip_flush_commands; 57@@global.binlog_skip_flush_commands 580 59SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 60VARIABLE_NAME VARIABLE_VALUE 61BINLOG_SKIP_FLUSH_COMMANDS OFF 62SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 63VARIABLE_NAME VARIABLE_VALUE 64BINLOG_SKIP_FLUSH_COMMANDS OFF 65SET GLOBAL binlog_skip_flush_commands = 1; 66SELECT @@global.binlog_skip_flush_commands; 67@@global.binlog_skip_flush_commands 681 69SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 70VARIABLE_NAME VARIABLE_VALUE 71BINLOG_SKIP_FLUSH_COMMANDS ON 72SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 73VARIABLE_NAME VARIABLE_VALUE 74BINLOG_SKIP_FLUSH_COMMANDS ON 75SET GLOBAL binlog_skip_flush_commands = 0; 76SELECT @@global.binlog_skip_flush_commands; 77@@global.binlog_skip_flush_commands 780 79SELECT * FROM information_schema.global_variables WHERE variable_name = 'binlog_skip_flush_commands'; 80VARIABLE_NAME VARIABLE_VALUE 81BINLOG_SKIP_FLUSH_COMMANDS OFF 82SELECT * FROM information_schema.session_variables WHERE variable_name = 'binlog_skip_flush_commands'; 83VARIABLE_NAME VARIABLE_VALUE 84BINLOG_SKIP_FLUSH_COMMANDS OFF 85SET SESSION binlog_skip_flush_commands = 'OFF'; 86ERROR HY000: Variable 'binlog_skip_flush_commands' is a GLOBAL variable and should be set with SET GLOBAL 87SET @@session.binlog_skip_flush_commands = 'ON'; 88ERROR HY000: Variable 'binlog_skip_flush_commands' is a GLOBAL variable and should be set with SET GLOBAL 89SET GLOBAL binlog_skip_flush_commands = 1.1; 90ERROR 42000: Incorrect argument type to variable 'binlog_skip_flush_commands' 91SET GLOBAL binlog_skip_flush_commands = 1e1; 92ERROR 42000: Incorrect argument type to variable 'binlog_skip_flush_commands' 93SET GLOBAL binlog_skip_flush_commands = 2; 94ERROR 42000: Variable 'binlog_skip_flush_commands' can't be set to the value of '2' 95SET GLOBAL binlog_skip_flush_commands = -3; 96ERROR 42000: Variable 'binlog_skip_flush_commands' can't be set to the value of '-3' 97SET GLOBAL binlog_skip_flush_commands = 'AUTO'; 98ERROR 42000: Variable 'binlog_skip_flush_commands' can't be set to the value of 'AUTO' 99SET GLOBAL binlog_skip_flush_commands = @start_global_value; 100SELECT @@global.binlog_skip_flush_commands; 101@@global.binlog_skip_flush_commands 1020 103