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 ...
Get MySQL® Database Design and Tuning 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.
