High Performance MySQL: Optimization, Backups, and Replication

Front Cover
"O'Reilly Media, Inc.", Mar 23, 2012 - Computers - 793 pages

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
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter 1 MySQL Architecture and History
1
Chapter 2 Benchmarking MySQL
35
Chapter 3 Profiling Server Performance
69
Chapter 4 Optimizing Schema and Data Types
115
Chapter 5 Indexing for High Performance
147
Chapter 6 Query Performance Optimization
201
Chapter 7 Advanced MySQL Features
265
Chapter 8 Optimizing Server Settings
331
Chapter 13 MySQL in the Cloud
589
Chapter 14 ApplicationLevel Optimization
605
Chapter 15 Backup and Recovery
621
Chapter 16 Tools for MySQL Users
665
Appendix A Forks and Variants of MySQL
679
Appendix B MySQL Server Status
685
Appendix C Transferring Large Files
715
Appendix D Using EXPLAIN
719

Chapter 9 Operating System and Hardware Optimization
387
Chapter 10 Replication
447
Chapter 11 Scaling MySQL
521
Chapter 12 High Availability
567
Appendix E Debugging Locks
735
Appendix F Using Sphinx with MySQL
745
Index
771
Copyright

Other editions - View all

Common terms and phrases

About the author (2012)

Baron Schwartz is Chief Performance Architect at Percona. He createstools and techniques to make MySQL easier to use and more dependable,and speaks regularly at conferences worldwide. He lives in Virginia with his family.

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. He serves as CEO of Percona, while keeping touch with his technical roots by continuing to do consulting for key customers.

Vadim Tkachenko is the CTO and co-founder of Percona, and an authoron the MySQLPerformanceBlog.com and SSDPerformanceBlog.com blogs. Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.

Bibliographic information