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_6

6. High-Level Lock Types

Jesper Wisborg Krogh¹  

(1)

Hornsby, NSW, Australia

 

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 ...