MariaDB makes use of a number of buffering, caching and threading techniques to improve performance.
| Title | Description |
|---|---|
| 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.
https://mariadb.com/kb/en/buffers-caches-and-threads/