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?
Both filesystems are very fast here.
What about executing queries? First, the simpler (read-only) ones:
… and the complex, (transactional, read-write) ones:
In Sysbench MySQL test we have a tie.
Will mysql-bench confirm these results? Let's see the overall result first:
...and then the detailed ones:
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.