1SET @start_global_value = @@global.innodb_replication_delay;
2SELECT @start_global_value;
3@start_global_value
40
5Valid values are zero or above
6select @@global.innodb_replication_delay >=0;
7@@global.innodb_replication_delay >=0
81
9select @@global.innodb_replication_delay;
10@@global.innodb_replication_delay
110
12select @@session.innodb_replication_delay;
13ERROR HY000: Variable 'innodb_replication_delay' is a GLOBAL variable
14show global variables like 'innodb_replication_delay';
15Variable_name	Value
16innodb_replication_delay	0
17show session variables like 'innodb_replication_delay';
18Variable_name	Value
19innodb_replication_delay	0
20select * from information_schema.global_variables where variable_name='innodb_replication_delay';
21VARIABLE_NAME	VARIABLE_VALUE
22INNODB_REPLICATION_DELAY	0
23select * from information_schema.session_variables where variable_name='innodb_replication_delay';
24VARIABLE_NAME	VARIABLE_VALUE
25INNODB_REPLICATION_DELAY	0
26set global innodb_replication_delay=10;
27select @@global.innodb_replication_delay;
28@@global.innodb_replication_delay
2910
30select * from information_schema.global_variables where variable_name='innodb_replication_delay';
31VARIABLE_NAME	VARIABLE_VALUE
32INNODB_REPLICATION_DELAY	10
33select * from information_schema.session_variables where variable_name='innodb_replication_delay';
34VARIABLE_NAME	VARIABLE_VALUE
35INNODB_REPLICATION_DELAY	10
36set session innodb_replication_delay=1;
37ERROR HY000: Variable 'innodb_replication_delay' is a GLOBAL variable and should be set with SET GLOBAL
38set global innodb_replication_delay=DEFAULT;
39select @@global.innodb_replication_delay;
40@@global.innodb_replication_delay
410
42set global innodb_replication_delay=0;
43select @@global.innodb_replication_delay;
44@@global.innodb_replication_delay
450
46set global innodb_replication_delay=65535;
47select @@global.innodb_replication_delay;
48@@global.innodb_replication_delay
4965535
50set global innodb_replication_delay=4294967295;
51select @@global.innodb_replication_delay;
52@@global.innodb_replication_delay
534294967295
54set global innodb_replication_delay=1.1;
55ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay'
56set global innodb_replication_delay=1e1;
57ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay'
58set global innodb_replication_delay="foo";
59ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay'
60set global innodb_replication_delay=' ';
61ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay'
62select @@global.innodb_replication_delay;
63@@global.innodb_replication_delay
644294967295
65set global innodb_replication_delay=" ";
66ERROR 42000: Incorrect argument type to variable 'innodb_replication_delay'
67select @@global.innodb_replication_delay;
68@@global.innodb_replication_delay
694294967295
70set global innodb_replication_delay=-7;
71Warnings:
72Warning	1292	Truncated incorrect innodb_replication_delay value: '-7'
73select @@global.innodb_replication_delay;
74@@global.innodb_replication_delay
750
76set global innodb_replication_delay=-1024;
77Warnings:
78Warning	1292	Truncated incorrect innodb_replication_delay value: '-1024'
79select @@global.innodb_replication_delay;
80@@global.innodb_replication_delay
810
82select * from information_schema.global_variables where variable_name='innodb_replication_delay';
83VARIABLE_NAME	VARIABLE_VALUE
84INNODB_REPLICATION_DELAY	0
85SET @@global.innodb_replication_delay = 4294967296;
86SELECT @@global.innodb_replication_delay IN (4294967296,4294967295);
87@@global.innodb_replication_delay IN (4294967296,4294967295)
881
89SET @@global.innodb_replication_delay = 12345678901;
90SELECT @@global.innodb_replication_delay IN (12345678901,4294967295);
91@@global.innodb_replication_delay IN (12345678901,4294967295)
921
93SET @@global.innodb_replication_delay = 18446744073709551615;
94SELECT @@global.innodb_replication_delay IN (18446744073709551615,4294967295);
95@@global.innodb_replication_delay IN (18446744073709551615,4294967295)
961
97SET @@global.innodb_replication_delay = @start_global_value;
98SELECT @@global.innodb_replication_delay;
99@@global.innodb_replication_delay
1000
101