2023-11-14, 02:08 PM
(2023-10-06, 03:57 PM)TheDreadPirate Wrote: Having your database on a ZFS file system is possible, it is very much not recommended. Database READ performance is fine, but when you are writing to a database that is on a ZFS file system there are serious performance penalties.
And because your database is big, that adds to the performance penalty.
If possible, move your database to an EXT4 file system.
Hi, it sounds like you have a fair bit of knowledge on this, and I'm curious. Why does a DB on ZFS have such a different performance than on EXT4?
Additionally, how does BTRFS stack up?
I've never really thought much about performance on different fs types, thank you for planting that seed in my head
I don't want to change my sig with every new version. I'm running whatever the currently packaged version for Ubuntu Server 22.04