Buffers, Caches and Threads

Optimize MariaDB Server performance by tuning buffers, caches, and threads. This section covers essential configurations to maximize throughput and responsiveness for your database workloads.

Query Cache

Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.

Thread Command Values

The COMMAND values a thread can show in SHOW PROCESSLIST, and what each one means.

Thread Pool

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.

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.

_{This page is licensed: CC BY-SA / Gnu FDL}