MySQL Concurrency
A guide to locking and transactions in MySQL — row and gap locks, metadata locks, isolation levels, and how to diagnose lock contention and deadlocks with the Performance and Information Schemas.
MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs walks through how MySQL and InnoDB handle concurrent access — transactions, isolation levels, row and gap locks, and metadata/schema locks — and how to use the Performance Schema and Information Schema to diagnose lock contention and deadlocks.
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 2021.
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.