3 ms·
I read this article and took away the conclusion that to get acceptable performance from ZFS compared to XFS, I have to do extensive tuning and throw in a half
by dekhn 8y ago
I read this article and took away the conclusion that to get acceptable performance from ZFS compared to XFS, I have to do extensive tuning and throw in a half terabyte of NVMe storage as a cache.
Not very impressive.
- fleitz 8y agoTechnically all of your data needs to be cached. He used a 600gB data set because with compression it fits on the 475 GB local drive. If he’s looking for performance what he should do is turn off fsync, write to the local NVMe, enable write caching, and copy the innodb WAL to S3. Who looks for performance & reliability and then thinks I know I’ll use EBS, so all my data is unavailable once every year or two and in the meantime I’ll pay exorbitant prices for low IOPS and 3x latency.
- viraptor 8y agoI agree they didn't present it very well. But in reality if you do want to get as much as possible out of your database, you'll need to look at tuning at that level anyway - regardless of the database, or the filesystem you use. I expect that XFS with bcache would need much less tuning up front though. Adding bcache in front of the original configuration should give a similar improvement to l2arc.