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

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

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