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.