Debian Codegraph @

mysql-test/suite/perfschema/t/idx_compare_replication_applier_status_by_worker.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_applier_status_by_worker;
17
18 select THREAD_ID
19 into @worker_thread_id
20 from performance_schema.replication_applier_status_by_worker
21 where WORKER_ID = 1
22 limit 1;
23
24 # Make sure we found a thread to have data to test.
25 select NAME from performance_schema.threads
26 where THREAD_ID = @worker_thread_id;
27
28 --source ../include/idx_compare_setup_index_test.inc
29
30 let $table = "replication_applier_status_by_worker";
31 SET @pfs_columns = "CHANNEL_NAME, WORKER_ID, THREAD_ID";
32 let $key_group = 18.1;
33 let $target_channel_name = '';
34 let $target_worker_id = 4;
35
36 --echo TABLE: $table
37 --echo INDEXES: PK (CHANNEL_NAME)
38
39 --source ../include/idx_compare_load.inc
40
41 let $key_group = 14;
42 let $id_column = THREAD_ID;
43 SET @target_id = @worker_thread_id;
44
45 --echo TABLE: $table
46 --echo INDEXES: THREAD_ID
47
48 --source ../include/idx_compare_load.inc
49
50 --source ../include/idx_compare_cleanup_index_test.inc
51
52 --connection slave
53 --source include/stop_slave.inc
54 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
55 --source include/start_slave.inc
56
57 --source include/rpl_end.inc
58