2
Buffers, Caches and Threads
Need help tuning your MariaDB database? Ask the experts!
Contact UsMariaDB makes use of a number of buffering, caching and threading techniques to improve performance.
-
Thread Pool
MariaDB thread pool -
Thread States
Descriptions of the various thread states -
InnoDB Buffer Pool
The most important memory buffer used by InnoDB. -
InnoDB Change Buffering
Buffering INSERT, UPDATE and DELETE statements for greater efficiency. -
Query Cache
Caching SELECT queries for better performance. -
Segmented Key Cache
Collection of structures for regular MyISAM key caches -
Subquery Cache
Subquery cache for optimizing the evaluation of correlated subqueries. -
Thread Command Values
Thread command values from SHOW PROCESSLIST or Information Schema PROCESSLIST Table
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.
