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