Abstract
Remember that the locking in MySQL and InnoDB is a means to provide concurrent access, and in general the fine-grained locking of InnoDB allows for a highly concurrent workload. Yet, if you have excessive locking, it will cause reduced concurrency and query pileups, and in the worst case, it can cause an application to come to a grinding halt and cause a poor user experience.
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). Reducing Locking Issues. In: MySQL Concurrency. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6652-6_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6652-6_9
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