Slave Connection Thread States
This article documents thread states that are related to connection threads that occur on a replication slave. These correspond to the
STATE values listed by the SHOW PROCESSLIST statement or in the Information Schema PROCESSLIST Table as well as the
PROCESSLIST_STATE value listed in the Performance Schema threads Table.
|Processing a CHANGE MASTER TO statement.
|Processing a STOP SLAVE statement.
|Opening master dump table
|A table has been created from a master dump and is now being opened.
|Reading master dump table data
|After the table created by a master dump (the
Opening master dump table state) the table is now being read.
|Rebuilding the index on master dump table
|After the table created by a master dump has been opened and read (the
Reading master dump table data state), the index is built.