Databasesmedium

Deadlock: what is it and how do databases resolve it?

Answer

A deadlock happens when two transactions wait on each other’s locks. Databases detect it and abort (rollback) one transaction so the other can continue. Apps should retry aborted transactions.

Related questions

Databases

Autocommit vs explicit transactions: when does it matter?

#database#transactions#autocommit

Databases

OLTP vs OLAP: what’s the difference?

#database#oltp#olap

Databases

Denormalization: when might you do it and what’s the trade‑off?

#database#denormalization#performance

Databases

Partitioning vs sharding: what’s the difference?

#database#partitioning#sharding

Databases

Isolation levels: what’s the difference between Read Committed, Repeatable Read, and Serializable?

#database#transactions#isolation

Databases

What is a covering index (index‑only scan) and why can it be faster?

#database#indexes#covering-index