When a database running on ZFS slows down, buying more hardware isn’t always the answer. The bottleneck could be storage, RAM, or CPU, and each has its own signal: latency histograms for storage, ARC demand hit ratio for RAM, worker-thread CPU time for CPU. Learn how to diagnose the real cause before spending money on hardware.
ZFS: Diagnosing Database Bottlenecks: Storage, RAM, or CPU?
Submitted 3 days ago by cm0002@suppo.fi to FreeBSD@lemmy.zip
https://klarasystems.com/articles/diagnosing-zfs-database-bottlenecks/