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?
It seems that XFS wins by a small margin.
What happen when we start to query the db?
In this simple, read-only test we have a tie.
Now, the complex, read-write, transactional test:
We have another virtual tie here.
Last but not least, we have the mysql-bench benchmark scores:
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:
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.