1SET @start_global_value = @@global.debug_binlog_fsync_sleep; 2select @@global.debug_binlog_fsync_sleep; 3@@global.debug_binlog_fsync_sleep 40 5select @@session.debug_binlog_fsync_sleep; 6ERROR HY000: Variable 'debug_binlog_fsync_sleep' is a GLOBAL variable 7show global variables like 'debug_binlog_fsync_sleep'; 8Variable_name Value 9debug_binlog_fsync_sleep 0 10show session variables like 'debug_binlog_fsync_sleep'; 11Variable_name Value 12debug_binlog_fsync_sleep 0 13select * from information_schema.global_variables where variable_name='debug_binlog_fsync_sleep'; 14VARIABLE_NAME VARIABLE_VALUE 15DEBUG_BINLOG_FSYNC_SLEEP 0 16select * from information_schema.session_variables where variable_name='debug_binlog_fsync_sleep'; 17VARIABLE_NAME VARIABLE_VALUE 18DEBUG_BINLOG_FSYNC_SLEEP 0 19set global debug_binlog_fsync_sleep=20; 20select @@global.debug_binlog_fsync_sleep; 21@@global.debug_binlog_fsync_sleep 2220 23set session debug_binlog_fsync_sleep=1; 24ERROR HY000: Variable 'debug_binlog_fsync_sleep' is a GLOBAL variable and should be set with SET GLOBAL 25set global debug_binlog_fsync_sleep=1.1; 26ERROR 42000: Incorrect argument type to variable 'debug_binlog_fsync_sleep' 27set global debug_binlog_fsync_sleep=1e1; 28ERROR 42000: Incorrect argument type to variable 'debug_binlog_fsync_sleep' 29set global debug_binlog_fsync_sleep="foo"; 30ERROR 42000: Incorrect argument type to variable 'debug_binlog_fsync_sleep' 31set global debug_binlog_fsync_sleep=0; 32select @@global.debug_binlog_fsync_sleep; 33@@global.debug_binlog_fsync_sleep 340 35set global debug_binlog_fsync_sleep=cast(-1 as unsigned int); 36Warnings: 37Note 1105 Cast to unsigned converted negative integer to it's positive complement 38Warning 1292 Truncated incorrect debug_binlog_fsync_sleep value: '18446744073709551615' 39select @@global.debug_binlog_fsync_sleep; 40@@global.debug_binlog_fsync_sleep 414294967295 42SET @@global.debug_binlog_fsync_sleep = @start_global_value; 43