Comments on: Update on fsync Performance https://www.percona.com/blog/update-on-fsync-performance/ Tue, 10 Mar 2020 13:02:03 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Yves Trudeau https://www.percona.com/blog/update-on-fsync-performance/#comment-10971914 Tue, 10 Mar 2020 13:02:03 +0000 https://www.percona.com/blog/?p=62293#comment-10971914 My Optane card has 3 partitions, 2 of 10GB and one with the remaining space. Keep in mind, this is not prod, just my home server. For ZFS, I use the 2nd for SLOG and the 3rd for cache (l2arc):

zpool add data log /dev/disk/by-id/nvme-INTEL_SSDPED1K375GA_PHKS750500FR375AGN-part2
zpool add data cache /dev/disk/by-id/nvme-INTEL_SSDPED1K375GA_PHKS750500FR375AGN-part3

My ZFS pool is named data. In any production environment, log should be a mirror from ideally 2 Optane cards. Losing the SLOG is pretty bad. 10GB for the SLOG is quite a lot.

]]> By: BK https://www.percona.com/blog/update-on-fsync-performance/#comment-10971912 Tue, 10 Mar 2020 02:38:34 +0000 https://www.percona.com/blog/?p=62293#comment-10971912 I read your article impressively.

I’d like to take an Optane for SLOG such as yours.
How do I configure the system?

]]> By: Li Ben https://www.percona.com/blog/update-on-fsync-performance/#comment-10971279 Mon, 14 Oct 2019 10:09:31 +0000 https://www.percona.com/blog/?p=62293#comment-10971279 In reply to Andy.

ZFS use a ssd ZIL will fast at first, but it’ll slow down when apply log to slow disks, unless all your fsync can convert to append style write.
But in real case, it’ll be mix of random-write and sequence write.

]]> By: Andy https://www.percona.com/blog/update-on-fsync-performance/#comment-10971216 Fri, 20 Sep 2019 05:07:07 +0000 https://www.percona.com/blog/?p=62293#comment-10971216 What about Optane used directly as a storage device but with ZFS instead of ext4 as the filesystem? Would ZFS be faster than ext4 in that case?

]]>