These thread states occur on a replication slave but are associated with connection threads, not with the I/O or SQL threads.
The thread is processing a CHANGE
MASTER statement.
Creating table from master dump
The slave is creating a table using the CREATE
TABLE statement contained in the dump from the
master. Used for LOAD TABLE FROM MASTER
and LOAD DATA FROM MASTER.
The thread is processing a SLAVE STOP
statement.
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.
The thread is starting the slave threads after processing
a successful LOAD DATA FROM MASTER load
operation.

User Comments
Add your own comment.