Abstract
Record lock contention is the most frequently encountered, but usually also the least intrusive as the default lock wait timeout is just 50 seconds, so there is not the same potential for queries pilling up. That said, there are cases – as will be shown – where record locks can cause MySQL to come to a grinding halt. This chapter will look into investigating InnoDB record lock issues in general and in more detail lock wait timeout issues. Investigating the specifics of deadlocks is deferred until the next chapter.
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). Case Study: Record-Level Locks. In: MySQL Concurrency. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6652-6_15
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6652-6_15
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