1SET @start_global_value = @@global.relay_log_recovery; 2SELECT @start_global_value; 3@start_global_value 40 5select @@global.relay_log_recovery; 6@@global.relay_log_recovery 70 8select @@session.relay_log_recovery; 9ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable 10show global variables like 'relay_log_recovery'; 11Variable_name Value 12relay_log_recovery OFF 13show session variables like 'relay_log_recovery'; 14Variable_name Value 15relay_log_recovery OFF 16select * from information_schema.global_variables where variable_name='relay_log_recovery'; 17VARIABLE_NAME VARIABLE_VALUE 18RELAY_LOG_RECOVERY OFF 19select * from information_schema.session_variables where variable_name='relay_log_recovery'; 20VARIABLE_NAME VARIABLE_VALUE 21RELAY_LOG_RECOVERY OFF 22set global relay_log_recovery=1; 23select @@global.relay_log_recovery; 24@@global.relay_log_recovery 251 26select * from information_schema.global_variables where variable_name='relay_log_recovery'; 27VARIABLE_NAME VARIABLE_VALUE 28RELAY_LOG_RECOVERY ON 29select * from information_schema.session_variables where variable_name='relay_log_recovery'; 30VARIABLE_NAME VARIABLE_VALUE 31RELAY_LOG_RECOVERY ON 32set global relay_log_recovery=OFF; 33select @@global.relay_log_recovery; 34@@global.relay_log_recovery 350 36select * from information_schema.global_variables where variable_name='relay_log_recovery'; 37VARIABLE_NAME VARIABLE_VALUE 38RELAY_LOG_RECOVERY OFF 39select * from information_schema.session_variables where variable_name='relay_log_recovery'; 40VARIABLE_NAME VARIABLE_VALUE 41RELAY_LOG_RECOVERY OFF 42set session relay_log_recovery=1; 43ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable and should be set with SET GLOBAL 44set global relay_log_recovery=1.1; 45ERROR 42000: Incorrect argument type to variable 'relay_log_recovery' 46set global relay_log_recovery=1e1; 47ERROR 42000: Incorrect argument type to variable 'relay_log_recovery' 48set global relay_log_recovery="foo"; 49ERROR 42000: Variable 'relay_log_recovery' can't be set to the value of 'foo' 50SET @@global.relay_log_recovery = @start_global_value; 51SELECT @@global.relay_log_recovery; 52@@global.relay_log_recovery 530 54