MySQL 8 Administrator???s Guide

Architecture

In this section, we will give a brief introduction to the major components of the InnoDB architecture:

• Buffer pool: Area of main memory where tables and indexing data are cached to speed up processing
• Change buffer: Special data structure where changes to secondary index pages are cached
• Adaptive Hash Index: Enables in-memory database, such as lookups, operations on systems with balanced and appropriate combinations of the buffer pool's memory and workload
• Redo log buffer: Memory area where data is held to be written on the redo log
• System tablespace: Storage area where the doublewrite buffer, undo logs, and the change buffer, prior to the MySQL 8 data dictionary information, are stored
• Doublewrite buffer: Storage area in the ...