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/