Debian Codegraph @

mysql-test/suite/sys_vars/r/relay_log_index_basic.result

raw
1 include/master-slave.inc
2 [connection master]
3 select @@global.relay_log_index;
4 @@global.relay_log_index
5 MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin.index
6 select @@session.relay_log_index;
7 ERROR HY000: Variable 'relay_log_index' is a GLOBAL variable
8 show global variables like 'relay_log_index';
9 Variable_name Value
10 relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin.index
11 show session variables like 'relay_log_index';
12 Variable_name Value
13 relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin.index
14 select * from information_schema.global_variables where variable_name='relay_log_index';
15 VARIABLE_NAME VARIABLE_VALUE
16 RELAY_LOG_INDEX MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin.index
17 select * from information_schema.session_variables where variable_name='relay_log_index';
18 VARIABLE_NAME VARIABLE_VALUE
19 RELAY_LOG_INDEX MYSQLTEST_VARDIR/mysqld.1/data/master-relay-bin.index
20 set global relay_log_index=1;
21 ERROR HY000: Variable 'relay_log_index' is a read only variable
22 set session relay_log_index=1;
23 ERROR HY000: Variable 'relay_log_index' is a read only variable
24 connection slave;
25 select @@global.relay_log_index;
26 @@global.relay_log_index
27 REPLACED
28 select @@session.relay_log_index;
29 ERROR HY000: Variable 'relay_log_index' is a GLOBAL variable
30 show global variables like 'relay_log_index';
31 Variable_name Value
32 relay_log_index REPLACED
33 show session variables like 'relay_log_index';
34 Variable_name Value
35 relay_log_index REPLACED
36 select * from information_schema.global_variables where variable_name='relay_log_index';
37 VARIABLE_NAME VARIABLE_VALUE
38 RELAY_LOG_INDEX REPLACED
39 select * from information_schema.session_variables where variable_name='relay_log_index';
40 VARIABLE_NAME VARIABLE_VALUE
41 RELAY_LOG_INDEX REPLACED
42 set global relay_log_index=1;
43 ERROR HY000: Variable 'relay_log_index' is a read only variable
44 set session relay_log_index=1;
45 ERROR HY000: Variable 'relay_log_index' is a read only variable
46 include/rpl_end.inc