MySQL Troubleshooting
A practical guide to diagnosing MySQL problems — from queries that return unexpected results to concurrency issues, server options, the server environment, and replication.
MySQL Troubleshooting: What To Do When Queries Don’t Work works from simple problems to complex ones: it starts with issues that can be reproduced on a single connection in isolation, then moves on to concurrency, server options, the server environment, and replication. Along the way it covers tools such as the slow query log, InnoDB monitors, and the Performance Schema.
The author, Sveta Smirnova, wrote it while a principal technical support engineer in the Bugs Verification Group of the MySQL Support Group at Oracle. Published by O’Reilly in 2012.
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.