Skip to main content

Buffer Pool & Memory Tuning

Learn Buffer Pool & Memory Tuning (MySQL Performance Tuning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction The InnoDB buffer pool caches table and index pages in RAM. Reading a cached page costs microseconds; reading from disk costs milliseconds, so buffer pool size is the biggest memory lever.

More lessons in MySQL Performance Tuning