Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 – Qasim Oct 16 '13 at 13:06

Take a look at which can be found here

share|improve this answer

I agree with Jan, 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 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 : Also, NeoLoad provides threshold values—derived from industry best practices—to raise relevant alerts.


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

protected by fossfreedom Jul 27 '15 at 12:35

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

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