A new OpenZFS article of mine is up at Klara!
Ever fretted about how to get the most out of your database’s storage performance? Here’s a nice chewy read to get you on track:
3 Likes
Super informative article again Jim. Kudos.
2 Likes
Thank you! It’s always nice to get some feedback. That’s one thing I miss about writing for Ars–the comment section.
(I think I might be the only Ars author to say that, but a challenging comment section, to me, is one of the best non monetary rewards of writing.)
1 Like
I would make sure to include ashift in that article for completeness.
It is not database-specific at all and it is not going to be new to regular readers of the blog so you may have considered it obvious. But it is the single most common performance footgun for people new to openzfs in practice and it is harder to undo than changing dataset properties. So I would make sure to include it for the sake of anyone who is finding that blog entry when running ZFS for the first time and who is testing DB workloads
Also, I would put zfs set sync=… instead of zfs set sync=disabled in the bold title or add a dangerous: in front, just in case a reader skims through.