IV. Optimizing and Tuning the MySQL Engine

10 General Server Performance and Parameters Tuning

11 MyISAM Performance Enhancement

12 InnoDB Performance Enhancement

13 Improving Disk Speed

14 Operating System, Web Server, and Connectivity Tuning

15 Improving Import and Export Operations

MySQL offers dozens of settings and parameters that administrators can use to control all aspects of their database servers. The next few chapters examine these settings from a system response perspective. They also cite any server-generated status messages that can help us understand our environment’s unique performance profile.

Chapter 10 delves into a collection of parameters that are useful regardless of your choice of database storage engine. Chapter ...

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.