Performance Blog

MySQL Performance Comparison

Posted on: June 11, 2008

We run an internally developed AMP benchmark to understand the performance characteristics of the AMP stack on various platforms.

We did some comparisons of the AMP stack in Cool Stack 1.2 with the one in Cool Stack 1.3. We didn’t see any signficant difference in performance in the Apache/PHP tier between the two versions. However, there is a dramatic improvement in performance in the MySQL tier using Cool Stack 1.3. Cool Stack 1.2 shipped with MySQL 5.0.45 and 1.3 now has MySQL 5.1.24.

The graph below shows the CPU utilization on the MySQL system at different load levels :

MySQL 5.1 is 4x more efficient than 5.0.45 ! There are improvements in the Query Cache and query optimization in MySQL 5.1, but at this point we are doing more analysis to understand the reasons for the dramatic performance increase. Here is another graph that shows the network throughput at different load levels :

It appears that some of that efficiency comes from driving much less load on the network as well. We know that the client API has changed in 5.1, but it is amazing how much of a difference it makes in terms of performance.

So, the bottom-line is : Upgrade to MySQL 5.1 in  Cool Stack 1.3 and share your experiences. I’m very interested in finding out what others see in terms of performance.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Shanti's Photo


Latest Tweets



%d bloggers like this: