MySQL / MariaDB DBA

Architecture & Internals for Administrators

Question

Buffer pool versus operating-system page cache: what does each cache for InnoDB?

Answer

The buffer pool caches InnoDB data and index pages for database access. The operating-system cache may cache file contents below InnoDB. Size the buffer pool as the primary database cache; avoid assuming both provide independent useful capacity. Applies to MySQL and MariaDB.

This is 1 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples