1# Default values
2SELECT @@GLOBAL.binlog_max_flush_queue_time;
3@@GLOBAL.binlog_max_flush_queue_time
40
5Warnings:
6Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
7SELECT @@SESSION.binlog_max_flush_queue_time;
8ERROR HY000: Variable 'binlog_max_flush_queue_time' is a GLOBAL variable
9SET @saved_value = @@global.binlog_max_flush_queue_time;
10Warnings:
11Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
12# Valid values
13SET GLOBAL binlog_max_flush_queue_time = 0;
14Warnings:
15Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
16SET GLOBAL binlog_max_flush_queue_time = 1;
17Warnings:
18Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
19SET GLOBAL binlog_max_flush_queue_time = 10000;
20Warnings:
21Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
22SET GLOBAL binlog_max_flush_queue_time = 100000;
23Warnings:
24Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
25# Invalid values: there shall be warnings about truncation
26SET GLOBAL binlog_max_flush_queue_time = -1;
27Warnings:
28Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
29Warning	1292	Truncated incorrect binlog_max_flush_queue_time value: '-1'
30SET GLOBAL binlog_max_flush_queue_time = -1024;
31Warnings:
32Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
33Warning	1292	Truncated incorrect binlog_max_flush_queue_time value: '-1024'
34SET GLOBAL binlog_max_flush_queue_time = 100001;
35Warnings:
36Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
37Warning	1292	Truncated incorrect binlog_max_flush_queue_time value: '100001'
38SET GLOBAL binlog_max_flush_queue_time = 200000;
39Warnings:
40Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
41Warning	1292	Truncated incorrect binlog_max_flush_queue_time value: '200000'
42SET GLOBAL binlog_max_flush_queue_time = @saved_value;
43Warnings:
44Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
45