> 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.md).

# Buffers, Caches and Threads

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

{% column %}
Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/JVJBbisgWIONhYGtXipZ" %}
[Thread Command Values](/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-command-values.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The COMMAND values a thread can show in SHOW PROCESSLIST, and what each one means.
{% endcolumn %}
{% endcolumns %}

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

{% column %}
Optimize MariaDB Server with the thread pool. This section explains how to manage connections and improve performance by efficiently handling concurrent client requests, reducing resource overhead.
{% endcolumn %}
{% endcolumns %}

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

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