Linux Kernel Comparison: 2.6.4 vs. 2.4.25 - MySQL Performance
Published on 2004-03-29 01:00:00 By: Jim_

We introduced MySQL Super Smack in our last article and it seemed to be well received. As a result, we'll use it again here in our comparison of kernels 2.6 and 2.4. Let's begin by taking a look at the read performance of our database server using the bundled smack file which runs two SELECT queries on our database.

Finally, we get what we've been waiting for; a sizeable victory. Based on these results, MySQL definitely likes the improvements 2.6 brings to the table. 2.6.4 bests 2.4.25 by approximately 19.2%. That's a considerable improvement considering all we're doing here is updating our kernel. To get an extra 20% of database performance without adding hardware or even updating the database software is certainly impressive. Those of you out there running MySQL on aging hardware with kernel 2.4 could jump to kernel 2.6 and possibly extend the life of your hardware for a little while longer.

Let's move on to the write performance of our database server, shall we?

I think it's pretty clear what kernel version we should be running if we're dependent on MySQL performance. By jumping to kernel 2.6 here we see an approximate 14.5% increase in database write performance. Impressive. It looks like I'm going to have some decisions to make regarding whether or not I make the jump to kernel 2.6 on our web server.

Let's move on to file server performance and then we'll wrap this article up with some concluding remarks.

[ Back to Page 3 ]
 
[ Next to Page 5 ]