Thread states can be viewed with 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. Slave_IO_State shown by SHOW SLAVE STATUS also shows slave-related thread states.
| Title | Description |
|---|---|
| Delayed Insert Connection Thread States | Thread states related to the connection thread that processes INSERT DELAYED statements |
| Delayed Insert Handler Thread States | Thread states related to the handler thread that inserts the results of INSERT DELAYED statements |
| Event Scheduler Thread States | Thread states related to the Event Scheduler |
| General Thread States | Thread states |
| Master Thread States | Thread states related to replication master threads |
| Query Cache Thread States | Thread states related to the query cache |
| Slave Connection Thread States | Thread states related to slave connection threads |
| Slave I/O Thread States | Thread states related to replication slave I/O threads |
| Slave SQL Thread States | Thread states related to replication slave SQL threads. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/thread-states/