High Performance MySQL: Optimization, Backups, and Replication"O'Reilly Media, Inc.", 5. 3. 2012. - 826 страница 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.
|
Садржај
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 |
771 | |