What Are ACID Properties in Databases?
ACID describes four guarantees a reliable database transaction system provides: Atomicity, Consistency, Isolation, and Durability.
Published November 19, 2026
ACID stands for Atomicity, Consistency, Isolation and Durability: the four guarantees that make database transactions reliable.
The concept
Atomicity: all of a transaction's steps happen or none do. Consistency: a transaction moves the database from one valid state to another, respecting constraints.
Isolation: concurrent transactions do not interfere with each other's intermediate states. Durability: once committed, data survives crashes (written to a log or disk).
The four letters
A tomicity all or nothing
C onsistency rules always hold
I solation no interference
D urability committed = permanent
Practical examples
Atomicity via rollback
BEGIN; UPDATE a ...; UPDATE b ...; ROLLBACK; -- neither appliesConsistency via constraints
ALTER TABLE accounts ADD CONSTRAINT chk_balance CHECK (balance >= 0);Durability
Write-ahead log is flushed before COMMIT returnsCommon mistakes
- Assuming every database is fully ACID by default.
- Using MyISAM (no transactions) in MySQL.
- Disabling fsync for speed.
Key takeaways
- Atomic, Consistent, Isolated, Durable.
- Relational databases emphasise ACID.
- Check your engine's guarantees.
FAQ
ACID vs BASE?
BASE (basically available, soft state, eventually consistent) favours availability in NoSQL.
Which MySQL engine is ACID?
InnoDB.