EXT4 vs XFS: large volumes with high-end RAID controller

Written by Gionatan Danti on . Posted in Linux & Unix

User Rating:  / 7
PoorBest 

MySQL benchmarks

It's now time for some database testing.

The first one is about creating and populating a MySQL database with 1 (one) million rows, using sysbench oltp prepare benchmark. Who is the faster between XFS and EXT4?

EXT4 vs XFS

Both filesystems are very fast here.

What about executing queries? First, the simpler (read-only) ones:

EXT4 vs XFS

… and the complex, (transactional, read-write) ones:

EXT4 vs XFS

In Sysbench MySQL test we have a tie.

Will mysql-bench confirm these results? Let's see the overall result first:

EXT4 vs XFS

...and then the detailed ones:

EXT4 vs XFS

Yes, we can confirm that EXT4 and XFS have identical performances when working with MySQL databases, at least on this high-end PERC H700 RAID controller.

Comments   

 
#1 Evgeny 2012-12-10 07:21
it's looks that you fsck time ext4 isn't true.
I think that you ran fsck.ext4 /dev/sd__something__
without "-f" key. It's means that fsck FS state
tune2fs -l
...
Filesystem state: clean
...
and if it clean do nothing
 

You have no rights to post comments