This chapter will build upon what was learned in the previous chapter, detailing how to use that knowledge to isolate and fix performance bottlenecks. It will take a lengthy look at the mysqlreport perl script, explaining how it summarizes many of the reports discussed in the previous chapter, and how to use this tool to tune your server for optimal performance. It will highlight the MySQL configuration options that most affect Drupal performance.
- Isolating Trouble Spots
- Tuning With mysqlreport
- Examples
- Deploying Changes
- The Tortoise and the Hare
- Historical Monitoring
- Controlled Experimentation
