Databasesmedium

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

Answer

Isolation defines what anomalies are allowed when transactions run concurrently (dirty/non-repeatable reads, phantoms). Higher isolation gives stronger correctness but may reduce concurrency and performance.

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

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

#deadlock#locking#transactions

Databases

Optimistic vs pessimistic locking — what’s the difference?

#locking#optimistic#pessimistic