Debian Codegraph @

mysql-test/suite/perfschema/t/idx_replication_connection_status.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2 # Test requires master-info-repository=TABLE, relay-log-info-repository=TABLE
3 --source include/have_slave_repository_type_table.inc
4 #setup
5 let $select_column = SERVICE_STATE;
6 let $table = performance_schema.replication_connection_status;
7
8 --disable_warnings
9 --source include/master-slave.inc
10
11 --connection slave
12
13 source include/stop_slave.inc;
14 RESET SLAVE ALL;
15 --disable_query_log
16 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$MASTER_MYPORT, SOURCE_DELAY=2 FOR CHANNEL 'channel_1';
17 --enable_query_log
18 source include/start_slave.inc;
19
20
21 select THREAD_ID from performance_schema.replication_connection_status
22 where CHANNEL_NAME = "channel_1"
23 into @tid;
24 --enable_warnings
25
26 ###########################################################################
27 # Test index on CHANNEL_NAME
28 ###########################################################################
29
30 let $column_count = 1;
31 let $col1 = CHANNEL_NAME;
32 let $col1_act = "channel_1";
33
34 --source ../include/idx_explain_test.inc
35
36 ###########################################################################
37 # Test index on THREAD_ID
38 ###########################################################################
39
40 let $column_count = 1;
41 let $col1 = THREAD_ID;
42 let $col1_act = @tid;
43
44 --source ../include/idx_explain_test.inc
45
46 # Cleanup
47 source include/stop_slave.inc;
48 RESET SLAVE ALL;
49 --disable_warnings
50 --disable_query_log
51 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root';
52 --enable_query_log
53 --enable_warnings
54 source include/start_slave.inc;
55 --connection master
56
57 --source include/rpl_end.inc