Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

What is the recommended tool(s) for testing the performance of MySQL 5.5 (innodb) under Ubuntu 12.04?

We have purchased a new multi-cpu multi-core server to replace our current MySQL dual-core server. However, the MySQL performance is worse than our current server! We know we need to tweak the innodb parameters but it would be helpful if there is a tool out there that would test and make recommendations.

share|improve this question
    
tools.percona.com –  Qasim Oct 16 '13 at 13:06

3 Answers 3

Take a look at mysqltuner.pl which can be found here

share|improve this answer

I agree with Jan, mysqltuner.pl is a fine tool for the first tuning steps of your MySQL server.

But MySQL is part of a whole IT system. Raw performance is one thing, but what about real-life performance? (I work as an engineer at Neotys, the software vendor of NeoLoad, a load testing tool since 2005.)

To complete your test, I advise you to take a look at NeoLoad (free 30-day evaluation on www.neotys.com) to validate the performance, robustness, and scalability of your server in the context of your application. You can record and generate load from the front-end of your IT system, and measure the performance of your MySQL server when your application is actually used.

For MySQL, here are the counters that NeoLoad monitors : http://www.neotys.com/product/monitoring-mysql-web-load-testing.html. Also, NeoLoad provides threshold values—derived from industry best practices—to raise relevant alerts.

Regards,

Hervé Servy, Neotys Performance Engineer

share|improve this answer
    
This is basically an advertisement for a commercial product, so I consider this to be spam. –  gertvdijk Oct 16 '13 at 12:20
    
@gertvdijk: This might be an advertisement but this does try to answer the question. It provides an alternative answer although it's a commercial product. Moreover the user isn't trying to hide this fact and he has explicitly mentioned his relation to the particular product. And he is not going to find each and every question and promote this affiliated product. Hence, I would not consider this as spam. Even faq used to mention that there is no problem if we mention about things we are affiliated with if we give an explicit disclosure (not able to find it right now). Am I mistaken somewhere? –  Aditya Oct 16 '13 at 12:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.