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