2 ms·
> ZFS is much less affected by the file level fragmentation, especially for point access type. I'm disappointed they didn't show that comparison. How much does
by viraptor 8y ago
> ZFS is much less affected by the file level fragmentation, especially for point access type.
I'm disappointed they didn't show that comparison. How much does the original result change in case of fragmented db files?
- ivan78 8y agoActually, it is quite opposite. ZFS is a copy-on-write filesystem - if you do write in the middle of your file the datablock gets moved to a new place on your disk. For typical database load your db files get more and more fragmented with time.