From In-Place Updates to In-Place Appends
Sergey Hardock, Ilia Petrov, Robert Gottstein, Alejandro Buchmann · 2017
Under update intensive workloads (TPC, LinkBench) small updates dominate the write behavior, e.g. 70% of all updates change less than 10 bytes across all TPC OLTP workloads. These are typically performed as in-place updates and result in random writes in page-granularity, causing major write-overhead on Flash storage, a write amplification of several hundred times and lower device longevity.