1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
#
# Verify that query results are the same with and without indexes.
#
--source include/master-slave.inc
# --source include/have_binlog_format_mixed.inc
--connection slave
--source include/stop_slave.inc
SET @old_replica_parallel_workers= @@global.replica_parallel_workers;
SET GLOBAL replica_parallel_workers= 4;
--source include/start_slave.inc
--connection slave
SELECT COUNT_TRANSACTIONS_RETRIES INTO @old_count_transactions_retries FROM
performance_schema.replication_applier_status;
--source ../include/idx_compare_setup_index_test.inc
# Debug
select CHANNEL_NAME, SERVICE_STATE, REMAINING_DELAY,
COUNT_TRANSACTIONS_RETRIES - @old_count_transactions_retries as should_be_zero FROM
performance_schema.replication_applier_status;
set @pfs_columns = "*";
let $table = "replication_applier_status";
let $key_group = 18;
let $target_channel_name = '';
--echo TABLE: $table
--echo INDEXES: PK (CHANNEL_NAME)
--source ../include/idx_compare_load.inc
--source ../include/idx_compare_cleanup_index_test.inc
--connection slave
--source include/stop_slave.inc
SET GLOBAL replica_parallel_workers= @old_replica_parallel_workers;
--source include/start_slave.inc
--source include/rpl_end.inc
|
