seniorSQL

What is write amplification in databases?

Updated May 17, 2026

Short answer

Write amplification occurs when a single logical write causes multiple physical writes.

Deep explanation

In databases and storage engines (especially LSM-tree systems), a single write may be rewritten multiple times due to compaction, indexing, replication, and WAL logging. This increases disk I/O and reduces SSD lifespan. High write amplification is a key performance concern in write-heavy systems.

Unlock with a Pro subscription to view this section.

View pricing

Real-world example

No real-world example available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Common mistakes

No common mistakes listed yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Follow-up questions

No follow-up questions available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

More SQL interview questions

View all →