MariaDB 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|
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.