Lock Management
Everything on SkillVeris tagged Lock Management — collected across the glossary, study notes, blog, and cheat sheets.
4 resources across 1 library
Interview Questions(4)
How Do Databases Detect Deadlocks?
Databases detect deadlocks by building a wait-for graph, where each transaction is a node and an edge points from a waiting transaction to the transaction hold…
What is Lock Escalation in Databases?
Lock escalation is when a database engine converts many fine-grained row-level or page-level locks held by a single transaction into one coarser table-level lo…
Row-Level Locking vs Table-Level Locking: What is the Difference?
Row-level locking locks only the specific rows a transaction reads or modifies, allowing many transactions to work on different rows of the same table concurre…
What are Advisory Locks and When Should You Use Them?
An advisory lock is an application-defined lock that the database manages on behalf of an arbitrary key you choose, rather than automatically on a row or table…