Back Issues/Search Home → Calendar → Archive → RSS → Subscribe → Services → Vendors → Blog → Current Issue → Popular → Newsletters (LinkedIn, Substack)

All issues › Volume 344, Issue 2 › IT Vendor News › Klara

ZFS: Which Storage Metrics Matter for Database Performance

Klara, Thursday, November 12th, 2026

Four ZFS metrics explain most database slowdowns: sync write latency, ARC demand hit ratio, I/O amplification and queue depth.

Klara presents a reference guide to the four ZFS storage metrics that matter most for PostgreSQL and MySQL/MariaDB performance.

Sync write latency sets a hard floor under commit latency, because a transaction cannot complete until its log record reaches stable storage.

The ARC demand hit ratio shows how often reads are served from RAM, I/O amplification can reveal a mismatch between database page size and ZFS recordsize, and queue depth shows where requests are waiting and whether the media, the pool layout or something above the filesystem is the limit.

The article advises a power-loss-protected SLOG device for slow sync writes and warns never to set sync=disabled.

more →  ·  More from Klara →