Debian Codegraph @

mysql-test/suite/perfschema/t/idx_replication_connection_configuration.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 = HOST;
6 let $table = performance_schema.replication_connection_configuration;
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 --enable_warnings
20
21 ###########################################################################
22 # Test index on CHANNEL_NAME
23 ###########################################################################
24
25 let $column_count = 1;
26 let $col1 = CHANNEL_NAME;
27 let $col1_act = "channel_1";
28
29 --source ../include/idx_explain_test.inc
30
31 # Cleanup
32 source include/stop_slave.inc;
33 RESET SLAVE ALL;
34 --disable_warnings
35 --disable_query_log
36 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root';
37 --enable_query_log
38 --enable_warnings
39 source include/start_slave.inc;
40 --connection master
41
42 --source include/rpl_end.inc