1
select @@global.relay_log;
4
select @@session.relay_log;
5
ERROR HY000: Variable 'relay_log' is a GLOBAL variable
6
show global variables like 'relay_log';
8
relay_log mysqld-relay-bin
9
show session variables like 'relay_log';
11
relay_log mysqld-relay-bin
12
select * from information_schema.global_variables where variable_name='relay_log';
13
VARIABLE_NAME VARIABLE_VALUE
14
RELAY_LOG mysqld-relay-bin
15
select * from information_schema.session_variables where variable_name='relay_log';
16
VARIABLE_NAME VARIABLE_VALUE
17
RELAY_LOG mysqld-relay-bin
18
set global relay_log=1;
19
ERROR HY000: Variable 'relay_log' is a read only variable
20
set session relay_log=1;
21
ERROR HY000: Variable 'relay_log' is a read only variable