What is the purpose of the InnoDB buffer pool?
- A To store query results permanently
- B To cache table and index data in memory
- C To hold the binary log
- D To store user credentials
Answer
To cache table and index data in memory
The buffer pool caches pages in RAM so reads avoid disk. Sizing it correctly, typically a large share of available memory, is the single most important InnoDB tuning parameter.





