Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2021 Jesper Wisborg Krogh
About this chapter
Cite this chapter
Krogh, J.W. (2021). Monitoring InnoDB Transactions. In: MySQL Concurrency. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6652-6_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6652-6_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6651-9
Online ISBN: 978-1-4842-6652-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books