This chapter will take a closer look at MySQL queries. It will examine the mysqlsla perl script, detailing how it is used to quickly track down the database queries that are wasting the greatest amount of resources. It will then explain how to determine why a query is performing poorly. It discuss how some queries can be optimized by adding indexes, while also looking at the impact of adding too many indexes to your tables. It will offer an in depth look at how MySQL indexes work, comparing indexes in MyISAM versus InnoDB. It will also review when to use multiple simple queries instead of complex queries. Throughout these chapter, specific Drupal examples will be provided.
- Revisiting the Slow Query Log
- configuration
- mysqlsla
- micro-second patches
- Query Performance
- Reviewing the devel Module
- Understanding Indexes
- Joining Tables
