Debian Codegraph @

mysql-test/suite/perfschema/t/idx_compare_replication_applier_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 --connection slave
16
17 SELECT COUNT_TRANSACTIONS_RETRIES INTO @old_count_transactions_retries FROM
18 performance_schema.replication_applier_status;
19 --source ../include/idx_compare_setup_index_test.inc
20
21 # Debug
22 select CHANNEL_NAME, SERVICE_STATE, REMAINING_DELAY,
23 COUNT_TRANSACTIONS_RETRIES - @old_count_transactions_retries as should_be_zero FROM
24 performance_schema.replication_applier_status;
25
26 set @pfs_columns = "*";
27 let $table = "replication_applier_status";
28 let $key_group = 18;
29 let $target_channel_name = '';
30
31 --echo TABLE: $table
32 --echo INDEXES: PK (CHANNEL_NAME)
33
34 --source ../include/idx_compare_load.inc
35
36 --source ../include/idx_compare_cleanup_index_test.inc
37
38 --connection slave
39 --source include/stop_slave.inc
40 SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
41 --source include/start_slave.inc
42
43 --source include/rpl_end.inc
44