8.9 Buffering and Caching

8.9.1 The InnoDB Buffer Pool
8.9.2 The MyISAM Key Cache
8.9.3 The MySQL Query Cache

MySQL uses several strategies that cache information in memory buffers to increase performance. Depending on your database architecture, you balance the size and layout of these areas, to provide the most performance benefit without wasting memory or exceeding available memory. When you set up or resize these memory areas, test the resulting performance using the techniques from Section 8.12, “Measuring Performance (Benchmarking)”.