1select @@global.relay_log_recovery; 2@@global.relay_log_recovery 30 4select @@session.relay_log_recovery; 5ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable 6show global variables like 'relay_log_recovery'; 7Variable_name Value 8relay_log_recovery OFF 9show session variables like 'relay_log_recovery'; 10Variable_name Value 11relay_log_recovery OFF 12select * from information_schema.global_variables where variable_name='relay_log_recovery'; 13VARIABLE_NAME VARIABLE_VALUE 14RELAY_LOG_RECOVERY OFF 15select * from information_schema.session_variables where variable_name='relay_log_recovery'; 16VARIABLE_NAME VARIABLE_VALUE 17RELAY_LOG_RECOVERY OFF 18set global relay_log_recovery=1; 19ERROR HY000: Variable 'relay_log_recovery' is a read only variable 20select @@global.relay_log_recovery; 21@@global.relay_log_recovery 220 23select * from information_schema.global_variables where variable_name='relay_log_recovery'; 24VARIABLE_NAME VARIABLE_VALUE 25RELAY_LOG_RECOVERY OFF 26select * from information_schema.session_variables where variable_name='relay_log_recovery'; 27VARIABLE_NAME VARIABLE_VALUE 28RELAY_LOG_RECOVERY OFF 29