Skip to main content

ACID Properties

Learn ACID Properties (Transactions, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction ACID is the contract of a transaction: Atomicity (all or nothing), Consistency (constraints hold before and after), Isolation (concurrent transactions do not see each other's half-done work), Durability (committed data survives a crash). InnoDB implements them with undo logs, redo log, locks/MVCC and the doublewrite buffer.

More lessons in Transactions