lock wait
Time a transaction spends waiting for another transaction to release a lock.
In more detail
Under overload lock waits lengthen, which is why a database gets slower rather than merely busier. Long lock waits hold connections and workers, spreading the slowdown.
Related terms
- contention — Many operations competing for the same resource, such as the same row or lock, at the same time.
- row lock — A database lock on one row that makes other transactions wait before changing it.
Taught in
- Worked Design One: Scaling The Ticket Booking System — Scalable System Design & Distributed Architecture