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. |
© 2019 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/