---
answer: direct
beat: system-design
source: 1 article · updated: November 14, 2026
---

Are row locks always better than table locks?

No. Row locks maximise concurrency but cost memory and bookkeeping per lock. A statement touching most of a table is cheaper with one table lock, which is why engines escalate. Choose granularity by how much of the data a transaction really touches.

Answered in

Database Locks Explained: Shared, Exclusive, Update, Key-Range and Granularity

What each lock mode allows, why update locks exist, how key-range locks stop phantoms, and when row, page or table locks cost you concurrency.

Crashtech Editorial November 14, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.