28 Locking
This chapter discusses how MySQL uses locking to handle concurrent data access by multiple clients. It covers the following exam topics:
Locking concepts
Using explicit table locks
Using advisory locks
Further discussion of locking issues is presented in Chapter 29, “Storage Engines.”
28.1 Locking Concepts
The MySQL server uses a multi-threaded architecture that enables it to service many clients concurrently (simultaneously). For each ...
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.
Start Free Trial
No credit card required