Which ZFS Storage Metrics Matter for Database Performance

Here using 16K recordsize for postgresl,mariadb & 64K recordsize for influxdb.
Note you can also tune "logbias" and "primarycache"
For me,
Code: 
 zfs get primarycache,logbias SSD/var/db/postgres SSD/var/db/mariadb SSD/var/db/influxd
NAME                 PROPERTY      VALUE         SOURCE
SSD/var/db/influxd   primarycache  metadata      local
SSD/var/db/influxd   logbias       latency       local
SSD/var/db/mariadb   primarycache  metadata      local
SSD/var/db/mariadb   logbias       latency       local
SSD/var/db/postgres  primarycache  metadata      local
SSD/var/db/postgres  logbias       throughput    local
 
You must log in or register to reply here.
Back
Top