Dailyy Notes

Checkpointing Tail Latency in SQLite WAL Mode

October 19, 2026 · 6 min read · Storage

Write-Ahead Logging decouples readers from single-writer transactions, yet passive checkpoints can stall under sustained read snapshots. Measuring frame accumulation under PRAGMA wal_autocheckpoint reveals predictable thresholds where TRUNCATE beats RESTART.

Page Cache Dirty Ratios on Small NVMe Instances

August 04, 2026 · 5 min read · Linux

Defaults like vm.dirty_ratio = 20 were tuned for spinning disks and workstations. On sub-2GB cloud instances running append-heavy workloads, tightening background writeback avoids multi-hundred-millisecond flush stalls.