10. General Server Performance Parameters and Tuning

Before getting started, it’s worth mentioning again: The most productive steps you can take to help most poorly performing database applications is to look at their indexing, followed by their SQL and application logic, and then their database design and other structural factors. At the very bottom of the list are the engine and other settings that you’re about to discover. However, these do have an impact, so it’s worth spending some time learning more about them.

To make things even easier for administrators, the past few years have seen MySQL AB bundling several prebuilt, configuration files for various processing profiles. While not necessarily optimized for your specific ...

Get MySQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.