Debian Codegraph @

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

raw
1 #
2 # Verify that query results are the same with and without indexes.
3 #
4
5 --source include/master-slave.inc
6 # --source include/have_binlog_format_mixed.inc
7
8 --connection slave
9
10 --source include/stop_slave.inc
11 SET @old_replica_parallel_workers= @@global.replica_parallel_workers;
12 SET GLOBAL replica_parallel_workers= 4;
13 --source include/start_slave.inc
14
15 # Debug
16 # select * from performance_schema.replication_connection_status;
17
18 select THREAD_ID
19 into @worker_thread_id
20 from performance_schema.replication_connection_status
21 limit 1;
22
23 # Make sure we found a thread to have data to test.
24 select NAME from performance_schema.threads
25 where THREAD_ID = @worker_thread_id;
26
27 # Debug
28 # select * from performance_schema.replication_connection_status
29 # where THREAD_ID = @worker_thread_id;
30
31 --source ../include/idx_compare_setup_index_test.inc
32
33 SET @pfs_columns = "CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE";
34 let $table = "replication_connection_status";
35 let $key_group = 18;
36 let $target_channel_name = '';
37
38 --echo TABLE: $table
39 --echo INDEXES: PK (CHANNEL_NAME)
40
41 --source ../include/idx_compare_load.inc
42
43 let $key_group = 14;
44 let $id_column = THREAD_ID;
45 SET @target_id = @worker_thread_id;
46
47 --echo TABLE: $table
48 --echo INDEXES: THREAD_ID
49
50 --source ../include/idx_compare_load.inc
51
52 --source ../include/idx_compare_cleanup_index_test.inc
53
54 --connection slave
55 --source include/stop_slave.inc
56 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
57 --source include/start_slave.inc
58
59 --source include/rpl_end.inc
60