E-Books →Efficient MySQL Performance (Second Early Release)

Daniel Nichter shows you how to apply best practices and techniques that directly affect efficient MySQL performance. You'll learn how to focus on query response time, optimize queries and data to increase performance, and monitor and understand the most important MySQL metrics. You'll also discover how not to use MySQL, including situations where this database is clearly the wrong choice.
Understand why query response time is the North Star of MySQL performance
Learn why indexing, not hardware or MySQL config, is the key to performance
Examine query metrics in detail, including aggregation, reporting, and analysis
Explore ways of improving query response time through query optimization
Understand how to monitor MySQL and learn what the metrics mean