Thread States
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.
-
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 -
Replica I/O Thread States
Thread states related to replica I/O threads -
Slave Connection Thread States
Thread states related to slave connection threads -
Slave SQL Thread States
Thread states related to replication slave SQL threads.
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.
