Red Hat Enterprise Linux 6 (RHEL6.1) vs Debian 6 - A performance comparison

Written by Gionatan Danti on . Posted in Linux & Unix

User Rating:  / 17
PoorBest 

MySQL performance

MySQL is one of the most used open source database systems. Good performances with this software will be beneficial not only to applications that use it directly but, as it is often used as a backend web storage, also to dynamic web page servicing.

We run various test against Red Hat and Debian MySQL installation. The first one is the time needed to populate a test database with 100K rows:

Red Hat vs Debian - Sysbench mysql prepare

As you can see, in this case I distinguished between EXT3 and EXT4 installations because the database tests are a disk/filesystems intensive ones. It seems that, while with the aging EXT3 filesystem Red Hat has some advantage, with the much more modern EXT4 filesystem we have a tie.

Lets see Sysbench simple test (select) results:

Red Hat vs Debian - Sysbench mysql simple

Red Hat seems to have a respectable ~15% advantage here.

What about the complex, transactional Sysbench test?

Red Hat vs Debian - Sysbench mysql complex

This disk-bound test show us no real differences.

Sysbench's results seems to suggest mostly similar performances between the two Linux systems, with some advantages for Red Hat in select-intensive database.

Will the MySQL integrated benchmark suite confirm this?

Red Hat vs Debian - MySQL Bench

It seems not: while the EXT3 Debian system is the slowest, the EXT4 Debian system is faster than the Red Hat one by about (you know!) ~15%.

In the end, it seems that Red Hat and Debian have quite comparable MySQL performances: one workload can favor one of them over the other, but we are not speaking about streaking differences.

Comments   

 
#1 David van Enckevort 2012-06-09 00:17
Although I do like your comparison between the two systems I don't think there is a real use case for using an off the shelf installation and being the fastest distribution. It will be much more efficient to look at tuning the distribution you are familiar with to give the best performance.
 
 
#2 Gionatan Danti 2012-06-11 15:52
Hi David,
I can see your point.

However, I saw many, many Linux hosts/services configured with default settings. In this case, the distribution-sp ecific default configuration will be a relevant part of the equation.

And other articles will cover application-spe cific tuning ;)

Regards.
 

You have no rights to post comments