Thread States
Understand MariaDB Server thread states. This section explains the different states a thread can be in, helping you monitor and troubleshoot query execution and server performance.
Lists the thread states for the connection thread that processes INSERT DELAYED statements, as shown by SHOW PROCESSLIST and related tables.
Lists the thread states for the handler thread that inserts the results of INSERT DELAYED statements, as shown by SHOW PROCESSLIST and related tables.
Lists the thread states related to event scheduling and execution, as shown by SHOW PROCESSLIST and related tables.
Lists the Galera Cluster-specific thread states shown in SHOW PROCESSLIST during cluster operations, such as certification, flow control, and Total Order Isolation DDL waits.
Documents the major general thread states shown by SHOW PROCESSLIST and related tables, with links to the more specific state lists for replication, the query cache, and other subsystems.
Lists the thread states related to replication primary (master) threads, as shown by SHOW PROCESSLIST and related tables.
Lists the thread states related to the query cache, as shown by SHOW PROCESSLIST and related tables.
Lists the replica I/O thread states shown by Slave_IO_State in SHOW REPLICA STATUS and by SHOW PROCESSLIST and related tables.
Lists the thread states for connection threads on a replication replica, as shown by SHOW PROCESSLIST and related tables.
Lists the replica SQL thread states shown by Slave_SQL_State in SHOW REPLICA STATUS and by SHOW PROCESSLIST and related tables, including parallel replication states.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?