> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states.md).

# Thread States

{% columns %}
{% column %}
{% content-ref url="/pages/QUf23ojxUERfyTf5CVMo" %}
[Delayed Insert Connection Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/delayed-insert-connection-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the thread states for the connection thread that processes INSERT DELAYED statements, as shown by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/5TDD3QZLHpMkE1knsf1e" %}
[Delayed Insert Handler Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/delayed-insert-handler-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the thread states for the handler thread that inserts the results of INSERT DELAYED statements, as shown by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/iCajHtInfhflGWZU5l1U" %}
[Event Scheduler Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/event-scheduler-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the thread states related to event scheduling and execution, as shown by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Ea0mBAnPgcmSBlczjCts" %}
[Galera Cluster Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/galera-cluster-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/nkxbV08nzxn0JIYiLS19" %}
[General Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/general-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/S8XLY4oYRlKThKZhFxOG" %}
[Master Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/master-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the thread states related to replication primary (master) threads, as shown by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/3SEGSmO8V5st5wooXL1x" %}
[Query Cache Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/query-cache-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the thread states related to the query cache, as shown by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/8qy7KYKmd9YDiQx9nm4u" %}
[Replica I/O Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/replica-io-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the replica I/O thread states shown by Slave\_IO\_State in SHOW REPLICA STATUS and by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ZEac5hD0YRIK8ofJEcuS" %}
[Replica Connection Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/slave-connection-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Lists the thread states for connection threads on a replication replica, as shown by SHOW PROCESSLIST and related tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/I4HwTyjQXF5DLKBnRMaf" %}
[Replica SQL Thread States](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/slave-sql-thread-states.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}