Much of the benefit of MySQL configuration comes from setting a few important options. This 15-page ebook explains MySQL configuration.
Get the most out of MySQL by focusing on a few important settings.
With hundreds of settings, MySQL configuration can be overwhelming. In recent years, this has become even more true, as MySQL has added features such as a more sophisticated query optimizer and multiple InnoDB buffer pools. And the default configuration samples shipped with the server are designed for avoidance of harm, not optimal performance.
Fortunately, the vast majority of the benefit comes from setting just a few very important options. Although special cases may benefit from setting more obscure options, the suggestions in this 15-page ebook will serve you well most of the time.