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 masterThe thread is processing a
CHANGE MASTER TOstatement.Killing slaveThe thread is processing a
STOP SLAVEstatement.Opening master dump tableThis state occurs after
Creating table from master dump.Reading master dump table dataThis state occurs after
Opening master dump table.Rebuilding the index on master dump tableThis state occurs after
Reading master dump table data.