MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

© Jesper Wisborg Krogh 2021

J. W. KroghMySQL Concurrencyhttps://doi.org/10.1007/978-1-4842-6652-6_2

2. Monitoring Locks and Mutexes

Jesper Wisborg Krogh¹  

(1)

Hornsby, NSW, Australia

 

Monitoring is essential to understanding where bottlenecks occur in your system. You need to use monitoring both to determine sources of contention and to verify that the changes you make reduce the contention.

This and the two following two chapters provide an overview of lock and mutex monitoring, InnoDB transaction monitoring, and general transaction monitoring in the Performance Schema. The remainder of the books shows examples of how you can use these monitoring resources to identify and investigate contention. Particularly Chapters 13–18 use monitoring extensively ...