Diagnosing and Fixing RocksDB WAL Sync Latency Spikes on NVMe
Summary We observed extreme P99.9 latency spikes (up to 500ms) in a high-performance C++ application utilizing RocksDB v8.5.x. The performance degradation occurred specifically during Write-Ahead Log (WAL) sync operations. Despite the underlying NVMe RAID-0 array reporting only 15% utilization (bandwidth and IOPS), the application threads were stalling on rocksdb::WritableFileWriter::Sync. This discrepancy between hardware throughput and … Read more