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 applies

Consistency via constraints

ALTER TABLE accounts ADD CONSTRAINT chk_balance CHECK (balance >= 0);

Durability

Write-ahead log is flushed before COMMIT returns

Common 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.

More SQL articles