# # 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