61 lines
1.5 KiB
Plaintext
61 lines
1.5 KiB
Plaintext
#
|
|
# 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_slave_parallel_workers= @@global.slave_parallel_workers;
|
|
SET GLOBAL slave_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 slave_parallel_workers= @old_slave_parallel_workers;
|
|
--source include/start_slave.inc
|
|
|
|
--source include/rpl_end.inc
|
|
|