Transactions and concurrency control¶
All topics · Alphabetical index
Concepts¶
- ACID; transaction boundaries; autocommit
- Read committed; repeatable read; serializable
- Dirty read; nonrepeatable read; phantom read
- Lost update; write skew; serialization anomaly
- MVCC; snapshot isolation; serializable snapshot isolation
- Optimistic concurrency; pessimistic concurrency; version columns
- Row locks; table locks; advisory locks; predicate locks
- Deadlock detection; lock ordering; lock timeout
- Compare-and-set; transaction retries; retry-safe operations
- WAL; crash recovery; two-phase locking; two-phase commit
Further reading¶
Reference links for this topic.