Chapter 37. Optimizing Queries

This chapter discusses how to use information provided by the MySQL optimizer to improve query execution times. It also describes how to set up key caches for buffering index information in memory. The chapter covers the following exam topics:

• Identifying candidates for query analysis

• Using EXPLAIN to analyze queries

• Using SHOW WARNINGS for optimization purposes

• Creating key caches for MyISAM tables