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.
| Value | Description |
|---|---|
| Changing master | Processing a CHANGE MASTER TO statement. |
| Killing slave | 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. |
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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/slave-connection-thread-states/