# Default values
SELECT @@GLOBAL.binlog_max_flush_queue_time;
@@GLOBAL.binlog_max_flush_queue_time
0
SELECT @@SESSION.binlog_max_flush_queue_time;
ERROR HY000: Variable 'binlog_max_flush_queue_time' is a GLOBAL variable
SET @saved_value = @@global.binlog_max_flush_queue_time;
# Valid values
SET GLOBAL binlog_max_flush_queue_time = 0;
SET GLOBAL binlog_max_flush_queue_time = 1;
SET GLOBAL binlog_max_flush_queue_time = 100000;
# Invalid values: there shall be warnings about truncation
SET GLOBAL binlog_max_flush_queue_time = -1;
Warnings:
Warning	1292	Truncated incorrect binlog_max_flush_queue_time value: '-1'
SET GLOBAL binlog_max_flush_queue_time = 100001;
Warnings:
Warning	1292	Truncated incorrect binlog_max_flush_queue_time value: '100001'
SET GLOBAL binlog_max_flush_queue_time = @saved_value;