June 18, 2013

Comment: Testing the Micron P320h

Vadim, indeed the difference between XFS and EXT4 is pretty surprising.. – did you monitor by chance the memory … the past I’ve observed that EXT4 still cached data even under O_DIRECT, while XFS not at all. This may also… was really x3 times more I/O ops on EXT4 than on XFS (as it should be fully IO-read-bound here…

Post: Testing the Micron P320h

… CentOS 6.3, and for the sysbench fileIO tests, the EXT4 filesystem was used. The card itself is the 700GB model… noting here that EXT4 outperforms XFS by a fairly significant margin. The approximate raw numbers, in tabular format, are: – EXT4 XFS 13GiB BP 22000…

Comment: Testing the Micron P320h

…. There was a performance regression in XFS in the pre-CentOS 6.4 kernels which made EXT4 faster, but this was supposedly… into a couple of situations where the latest version of XFS (on CentOS 6.4) crashes the box with a kernel…

Comment: Testing the Micron P320h

1) Would you recommend EXT4 over XFS for MySQL on SSD? What about Btrfs or ZFS? Seems …

Post: ext4 vs xfs on SSD

… KiB blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is… see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly…

Comment: ext4 vs xfs on SSD

… throughput being in GB/s sync async threads throughput throughput XFS ext4 XFS ext4 1 1.90/124k 1.41/92k 1.72/112k… from these results that lock contention is killing XFS as the thread count grows. ext4 performance shows that it uses exclusive locking… runs at 100% CPU utilsation, and XFS gets up to 3x as much throughput as ext4 does. Other testing I’ve done…

Comment: ext4 vs xfs on SSD

… MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the… performance of ext4 and XFS on the hardware we bought. I found that ext4 worked really well out of the box, while XFS required… beat ext4: http://blog.tsunanet.net/2011/09/ext4-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4, and…

Comment: ext4 vs xfs on SSD

… to ext4, but I had Domas’ claims in my mind that xfs is superior. So I recreated the benchmark fs as xfs and… 28% faster (2345 tps vs. 1829 tps). At 64 threads ext4 was even 47% faster (2362 tps vs. 1601 tps). At higher concurrency ext4 lost it’s bite, but was still constantly better than xfs. I did not look deeper…

Comment: ext4 vs xfs on SSD

… waiting for fix in RedHat, until that I will consider ext4 as good alternative. That’s a very short-sighted response… XFS) will prevail, and all that will have resulted is that you have a bunch of unhappy people left using ext4 because… production on the back of your recommendation….. Recommend ext4 for the right reasons – XFS having a performance regression isn’t one of…

Comment: btrfs - probably not ready yet

Andy, you may see discussion ext4 vs xfs there http://www.mysqlperformanceblog.com/2012/03/15/ext4-vs-xfs-on-ssd/ In short: at this point of time, my opinion, that ext4 can provide better throughput. But feature wise you may decide for yourself.