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