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.

Changing masterProcessing a CHANGE MASTER TO statement.
Killing slaveProcessing a STOP SLAVE statement.
Opening master dump tableA table has been created from a master dump and is now being opened.
Reading master dump table dataAfter 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 tableAfter the table created by a master dump has been opened and read (the Reading master dump table data state), the index is built.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.