High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL’s full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You’ll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include:
The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
Chapter 1 MySQL Architecture
Chapter 2 Finding Bottlenecks: Benchmarking and Profiling
Chapter 3 Schema Optimization and Indexing
Chapter 4 Query Performance Optimization
Chapter 5 Advanced MySQL Features
Chapter 6 Optimizing Server Settings
Chapter 7 Operating System and Hardware Optimization
Chapter 8 Replication
Chapter 9 Scaling and High Availability
Chapter 10 Application-Level Optimization
Chapter 11 Backup and Recovery
Chapter 12 Security
Chapter 13 MySQL Server Status
Chapter 14 Tools for High Performance
A Transferring Large Files
B Using EXPLAIN
C Using Sphinx with MySQL
D Debugging Locks
