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

11. MyISAM Performance Enhancement

After completing the discussion of general-purpose tuning parameters, this chapter devotes attention to MyISAM-specific performance enhancement. This chapter is divided into three main sections:

Optimal MyISAM data storage—Administrators have significant opportunities to squeeze more speed from MyISAM’s use of data storage. This section begins by examining how to interpret some important statistics from the myisamchk utility, as well as improve its performance during table repair. Next, it looks at how to customize several key MyISAM settings to tune sort performance.

Taking advantage of memory for better MyISAM performance—MyISAM offers a memory-based cache to hold index key values. Known ...

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