O'Reilly logo

MySQL by Robert D. Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required