buffer pool
The memory area that holds cached InnoDB data for both tables and indexes. For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. For efficiency of cache management, the buffer pool is implemented as a linked list of pages; data that is rarely used is aged out of the cache, using a variation of the LRU algorithm. On systems with large memory, you can improve concurrency by dividing the buffer pool into multiple buffer pool instances.
Several InnoDB
status variables, information-schema
tables, and performance-schema
tables help to monitor the internal workings of the buffer pool. Starting in MariaDB 5.6, you can also dump and restore the contents of the buffer pool, either automatically during shutdown and restart, or manually at any time, through a set of InnoDB
configuration variables such as innodb_buffer_pool_dump_at_shutdown
and innodb_buffer_pool_load_at_startup
.
See also buffer pool instance.
See also LRU.
See also page.
See also warm up.