Write amplification
Write amplification is the ratio of physical data-writing work to the logical data-writing work requested.
Crack Any Codebase with AI
Write amplification is the increase in physical write work caused when one logical data change must update multiple stored structures such as indexes.
- How it is used
- Audits schema indexes for hidden write costs before judging whether a table will scale in production.
- How deep it goes
- Explains the physical write mechanism, quantifies a nine-write example, and stops short of storage-engine internals.
- Examples
- Uses Cal.com's Booking table, its eight indexes, and an append-only audit-log comparison.
- What you can do after
- Evaluate index sets by estimating write penalties against read frequency and checking foreign-key coverage.
Read how Crack Any Codebase with AI explains write amplification →
ScyllaDB in Action
Write amplification is the amount of data written by a storage system relative to the original data size.
- How it is used
- Guides compaction-strategy selection by exposing the disk-bandwidth cost of rewriting data.
- How deep it goes
- Defines the metric and compares typical STCS and LCS values, but stops short of calculating workload-specific amplification.
- Examples
- Compares approximately 4× amplification for STCS with approximately 10× for LCS.
- What you can do after
- Evaluate compaction strategies by balancing write bandwidth against compacting disk-space requirements.
Related concepts
- indexingproduced by · Indexing is the process of assigning or using positions, keys, or lookup structures to identify and access elements or records.
- leveled compaction strategymeasured by · Leveled compaction strategy is an SSTable compaction strategy that organizes fixed-size files into levels with non-overlapping key ranges within each level.
Questions about write amplification
What is write amplification?
Write amplification is the ratio of physical data-writing work to the logical data-writing work requested.
Which Manning books explain write amplification?
Crack Any Codebase with AI and ScyllaDB in Action.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.

