28 Locking

This chapter discusses how MySQL uses locking to handle concurrent data access by multiple clients. It covers the following exam topics:

Image Locking concepts

Image Using explicit table locks

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

Get MySQL 5.0 Certification Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.