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_3

3. Monitoring InnoDB Transactions

Jesper Wisborg Krogh¹  

(1)

Hornsby, NSW, Australia

 

In the previous chapter, you learned how to find information about locks at a relatively low level. It is also important to include information at a higher level as locks have a duration up to the completion of the transaction. (Exceptions are user locks and explicit table locks which can last for longer.) In MySQL Server, transactions mean InnoDB, and this chapter focuses on monitoring InnoDB transactions.

First the INNODB_TRX view in the Information Schema will be covered. This is often the most important resource when it comes to investigating ongoing transactions. ...