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)”.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices