Abstract
In the previous chapter, you learned about the shared and exclusive access levels. In principle, you can make a locking system that does not consist of anything but one type of lock that can either be shared or exclusive. It would however mean that it would have to work at the instance level and thus be very poorly at allowing concurrent read-write access to the data. In this and the next chapter, you will learn how there are many kinds of locks depending on the resource they protect. While this does make locking much more complex, it does also allow for a much fine grainer locks that leads to support for a higher concurrency.
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). High-Level Lock Types. In: MySQL Concurrency. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6652-6_6
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6652-6_6
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