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

Written by Gionatan Danti on . Posted in Linux & Unix

User Rating:  / 16

MySQL benchmarks

UPDATE 05/04/2011: I added the detailed mysql-bench results graph.

It's now time for some database testing.

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

Sysbench mysql prepare time

It seems that XFS wins by a small margin.

What happen when we start to query the db?

Sysbench mysql simple test

In this simple, read-only test we have a tie.

Now, the complex, read-write, transactional test:

Sysbench mysql complex test

We have another virtual tie here.

Last but not least, we have the mysql-bench benchmark scores:

Mysql-bench results

Please note that this benchmark tests various aspects of a MySQL database, and some of them are not directly influenced by I/O speed. So, the XFS's win is a quite remarkable one.

At the end, have a look at detailed mysql-bench report:

Detailed mysql-bench results

So, summarizing MySQL results, we can conclude that while XFS is slight faster then EXT4, you can not go wrong with any of these two filesystems.


#1 musculare 2014-04-13 09:08
Spot on with this write-up, I absolutely think this website needs far more attention.
I'll probably be back again to see more, thanks for the info!

You have no rights to post comments