8.12.5.8. Replication Slave Connection Thread States

These thread states occur on a replication slave but are associated with connection threads, not with the I/O or SQL threads.

Changing master

The thread is processing a CHANGE MASTER TO statement.
Killing slave

The thread is processing a STOP SLAVE statement.
Opening master dump table

This state occurs after Creating table from master dump.
Reading master dump table data

This state occurs after Opening master dump table.
Rebuilding the index on master dump table

This state occurs after Reading master dump table data.