Friday, March 29, 2024

High Performance MySQL

High Performance MySQL cover

This O’Reilly publication is one of the more popular titles for MySQL resources.

The original version was written by Jeremy Zawodny and Derek Balling in 2004. The current second edition is a greatly enhanced version written by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko from Percona.

Table of Contents

  1. MySQL Architecture
  2. Finding Bottlenecks: Benchmarking and Profiling
  3. Schema Optimization and Indexing
  4. Query Performance Optimization
  5. Advanced MySQL Features
  6. Optimizing Server Settings
  7. Operating System and Hardware Optimization
  8. Replication
  9. Scaling and High Availability
  10. Application-Level Optimization
  11. Backup and Recovery
  12. Security
  13. MySQL Server Status
  14. Tools for High Performance