High Performance MySQL: Optimization, Backups, Replication, and More

Front Cover

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:

  • Emphasis throughout on both performance and reliability
  • Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine
  • Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views
  • A detailed discussion on how to build very large, highly scalable systems with MySQL
  • New options for backups and replication
  • Optimization of advanced querying features, such as full-text searches
  • Four new appendices

The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

 

What people are saying - Write a review

User ratings

5 stars
7
4 stars
7
3 stars
0
2 stars
0
1 star
0

User Review - Flag as inappropriate

good starter book looking mysql performance and diagnosing problems

User Review - Flag as inappropriate

very very very good book im learn from that special thanks

Contents

MySQL Architecture
1
Benchmarking and Profiling
32
Schema Optimization and Indexing
80
Query Performance Optimization
152
Advanced MySQL Features
204
Optimizing Server Settings
265
Operating System and Hardware Optimization
305
Replication
343
Backup and Recovery
472
Security
521
MySQL Server Status
557
Tools for High Performance
583
Transferring Large Files
603
Using EXPLAIN
607
Using Sphinx with MySQL
623
Debugging Locks
650

Scaling and High Availability
409
ApplicationLevel Optimization
457

Common terms and phrases

Bibliographic information