MySQL Database Design and Tuning, Chapter 18

MySQL Database Design and Tuning, Chapter 18: Case Study - Solving a Broad Collection of Performance Problems

What's an open source-based, fast-growing airline to do? In the attached article (taken from MySQL Database Design and Tuning, just published by MySQL Press), Robert Schneider describes the database performance challenges faced by the MySQL experts at High Hat Airways. The article begins by portraying a scenario that's probably all-too-familiar to the reader: what happens when an application is rushed into production without a realistic QA and performance testing plan?

After setting the stage, this case study then reviews a broad-based collection of performance problems, along with their solutions. Resolutions include a variety of easily-implemented modifications, from better table and query design through engine tuning and replication strategies. The article also references content from the book to help the reader gain deeper understanding of the many ways to improve MySQL database and application responsiveness.

Read-on

To download the entire chapter in PDF format, click here » (no registration required!)