1. Chapter 1 Back To Basics

   1. Binary Versus Compiled-From-Source Installations

   2. Configuration Files

   3. The SHOW Commands

2. Chapter 2 Storage Engines (Table Types)

   1. MySQL Architecture

   2. Locking and Concurrency

   3. Transactions

   4. Selecting the Right Engine

   5. The Storage Engines

3. Chapter 3 Benchmarking

   1. The Importance of Benchmarking

   2. Benchmarking Strategies

   3. Benchmarking Tools

4. Chapter 4 Indexes

   1. Indexing Basics

   2. Index Structures

   3. Indexes and Table Types

   4. Index Maintenance

5. Chapter 5 Query Performance

   1. Query Processing Basics

   2. Optimizer Features and Oddities

   3. Identifying Slow Queries

   4. Influencing MySQL with Hints

   5. Stupid Query Tricks

6. Chapter 6 Server Performance Tuning

   1. Performance-Limiting Factors

   2. RAID

   3. Operating System

   4. Techniques

7. Chapter 7 Replication

   1. Replication Overview

   2. Configuring Replication

   3. Under the Hood

   4. Replication Architectures

   5. Administration and Maintenance

   6. Common Problems

   7. The Future of Replication

8. Chapter 8 Load Balancing and High Availability

   1. Load Balancing Basics

   2. Configuration Issues

   3. Cluster Partitioning

   4. High Availability

9. Chapter 9 Backup and Recovery

   1. Why Backups?

   2. Considerations and Tradeoffs

   3. Tools and Techniques

   4. Rolling Your Own Backup Script

10. Chapter 10 Security

    1. Account Basics

    2. The Grant Tables

    3. Grant and Revoke

    4. Operating System Security

    5. Network Security

    6. Data Encryption

    7. MySQL in a chrooted Environment

1. Appendix A The SHOW STATUS and SHOW INNODB STATUS Commands

   1. SHOW STATUS

   2. SHOW INNODB STATUS

2. Appendix B mytop

   1. Overview

   2. Getting mytop

   3. Configuration and Usage

   4. Common Tasks

3. Appendix C phpMyAdmin

   1. The Basics

   2. Practical Examples

4. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of High Performance MySQL: Optimization, Backups, Replication, and Load Balancing, is a sparrow hawk (Accipiter nisus), a small woodland member of the falcon family found in Eurasia and North Africa. Sparrow hawks have a long tail and short wings; males are bluish-grey with a light brown breast, and females are more brown-grey and have an almost fully white breast. Males are normally somewhat smaller (11 inches) than females (15 inches).

Sparrow hawks live in coniferous woods and feed on small mammals, insects, and birds. They nest in trees and sometimes on cliff ledges. At the beginning of the summer, the female lays 4 to 6 white eggs, blotched red and brown, in a nest made in the boughs of the tallest tree available. The male feeds the female and their young.

Like all hawks, the sparrow hawk is capable of bursts of high speed in flight. Whether soaring or gliding, the sparrow hawk has a characteristic flap-flap-glide action; its large tail enables the hawk to twist and turn effortlessly in and out of cover. Mary Anne Weeks Mayo was the production editor and proofreader, and Leanne Soylemez was the copyeditor for High Performance MySQL: Optimization, Backups, Replication, and Load Balancing. Emily Quill and Claire Cloutier provided quality control. Jamie Peppard and Mary Agner provided production assistance. John Bickelhaupt wrote the index.

Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.

David Futato designed the interior layout. This book was converted by Joe Wizda to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop6. The tipand warning icons were drawn by Christopher Bing. This colophon was compiled by Mary Anne Weeks Mayo.