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/