contention
Many operations competing for the same resource, such as the same row or lock, at the same time.
In more detail
Under contention effective throughput can fall instead of flattening, as lock waits and retries grow. It is highest on hot keys and hot rows.
Related terms
- lock wait — Time a transaction spends waiting for another transaction to release a lock.
- overload collapse — A drop in useful throughput caused by accepting more work than a system can handle.
- hot key — A single key that receives a large share of all traffic, such as a celebrity account or a popular event.
Taught in
- Worked Design One: Ticket Booking, Correctness First — Scalable System Design & Distributed Architecture
- Worked Design One: Scaling The Ticket Booking System — Scalable System Design & Distributed Architecture