High Performance MySQL, 3rd Edition

03/29/2012 · No Responses

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
Implement improvements in replication, high availability, and clustering
Achieve high performance when running MySQL in the cloud
Optimize advanced querying features, such as full-text searches
Take advantage of modern multi-core CPUs and solid-state disks
Explore backup and recovery strategies—including new tools for hot online backups

Table of Contents
Chapter 1. MySQL Architecture and History
Chapter 2. Benchmarking MySQL
Chapter 3. Profiling Server Performance
Chapter 4. Optimizing Schema and Data Types
Chapter 5. Indexing for High Performance
Chapter 6. Query Performance Optimization
Chapter 7. Advanced MySQL Features
Chapter 8. Optimizing Server Settings
Chapter 9. Operating System and Hardware Optimization
Chapter 10. Replication
Chapter 11. Scaling MySQL
Chapter 12. High Availability
Chapter 13. MySQL in the Cloud
Chapter 14. Application-Level Optimization
Chapter 15. Backup and Recovery
Chapter 16. Tools for MySQL Users

Appendix A. Forks and Variants of MySQL
Appendix B. MySQL Server Status
Appendix C. Transferring Large Files
Appendix D. Using EXPLAIN
Appendix E. Debugging Locks
Appendix F. Using Sphinx with MySQL