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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
#
# 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
# Debug
# select * from performance_schema.replication_connection_status;
select THREAD_ID
into @worker_thread_id
from performance_schema.replication_connection_status
limit 1;
# Make sure we found a thread to have data to test.
select NAME from performance_schema.threads
where THREAD_ID = @worker_thread_id;
# Debug
# select * from performance_schema.replication_connection_status
# where THREAD_ID = @worker_thread_id;
--source ../include/idx_compare_setup_index_test.inc
SET @pfs_columns = "CHANNEL_NAME, GROUP_NAME, SOURCE_UUID, THREAD_ID, SERVICE_STATE";
let $table = "replication_connection_status";
let $key_group = 18;
let $target_channel_name = '';
--echo TABLE: $table
--echo INDEXES: PK (CHANNEL_NAME)
--source ../include/idx_compare_load.inc
let $key_group = 14;
let $id_column = THREAD_ID;
SET @target_id = @worker_thread_id;
--echo TABLE: $table
--echo INDEXES: THREAD_ID
--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
|
