MySQL 8 Query Performance Tuning
A systematic, step-by-step method for finding and fixing slow MySQL queries — from EXPLAIN and EXPLAIN ANALYZE through the Performance Schema and sys schema.
MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds walks through a repeatable process for query tuning: monitoring execution times, identifying which queries are worth optimizing, analyzing their current execution plans, and improving them — using both the traditional EXPLAIN command and MySQL 8’s EXPLAIN ANALYZE.
The author, Jesper Wisborg Krogh, has worked with MySQL since 2006 as an SQL developer, DBA, and member of the Oracle MySQL Support team, with a particular focus on performance tuning and the Performance and sys schemas. Published by Apress in 2020.
Community feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.