Databaseshard

What is a deadlock in a database and how do you reduce it?

Answer

A deadlock is when transactions wait on each other’s locks in a cycle, so none can proceed. Reduce it by keeping transactions short, locking rows in a consistent order, and retrying on deadlock errors.

Related questions

Databases

Autocommit vs explicit transactions: when does it matter?

#database#transactions#autocommit

Databases

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

#database#transactions#isolation

Databases

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

#database#transactions#locks

Databases

Why are long transactions dangerous in production databases?

#transactions#locks#mvcc

Databases

Optimistic vs pessimistic locking — what’s the difference?

#locking#optimistic#pessimistic

Databases

What is an isolation level (and why do we care)?

#transactions#isolation#concurrency