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