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 pricingReal-world example
No real-world example available yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProCommon mistakes
No common mistakes listed yet.
Unlock with a Pro subscription to view this section.
Upgrade to ProFollow-up questions
No follow-up questions available yet.
Unlock with a Pro subscription to view this section.
Upgrade to Pro