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 TO 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.