I've heard a long time ago that there is this tool that helps you tweek mysql settings for better performance but i can't seam to find it. I am aware that I can use ab for apache to simulate high traffic and it will generate me a slow log. However, if it crashes (already happened and it was in production mode), I don't know why it crashed and if it can be tweeked from the config.
closed as off-topic by Paul White says GoFundMonica♦, Philᵀᴹ, Aaron Bertrand♦ Jan 26 '15 at 14:41
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White says GoFundMonica, Philᵀᴹ, Aaron Bertrand
Benchmarking or Tuning tool?
IMHO, there's no tool that will be specific to the latter unless you have a super generic usage. You need to identify your usage pattern and tune your database hosts to accommodate. If you're write-heavy, you will have a different configuration than a read-heavy scenario. Bottom line, your tuning follows your applications usage.
Added: Here's my beef with config tools: With the changes in versions 4.x vs 5.x vs 5.5.x there are a lot of tweaks that don't jive between them. So you really need a savvy DBA to evaluate what's going on for each host. Load, storage, traffic, application specific requirements, there's a lot that can go into an optimal configuration. A tool may get you part of the way, but may leave out something or include something that may cause a failure. From buffers to flushing to plugins to threading, a config tool may provide you with false confidence that you are implementing the correct config.
I think MONyog can handle some of your request.
MONyog MySQL Monitor and Advisor is a "MySQL DBA in a box" that helps MySQL DBAs manage more MySQL servers, tune their MySQL servers and fix problems with MySQL database applications.
MONyog not only finds problem SQL it has 200+ monitors and advisors as well which suggests what parameter you should use for MySQL system variables (by editing
my.cnf/my.ini file) this helps in fine-tune your MySQL server.
Further there are so many features that DBA would like to have in his day-to-day activites like trend report, Dashboard, Server config management, SNMP/SMTP alerts etc.. for more details you can refer this :
Quest has a database benchmarking tool. You can run a synthetic TPC-C, H, E test against your MySQL database. It will not suggest configuration changes, but it does make testing those changes a bit easier. Benchmark Factory Community
It seems like your request could also be are there any tuning tools for MySQL? There are serveral:
- phpMyAdmin Advisor
- phpMyAdmin Advisor
and some nice tuning suggestions at: http://web3us.com/drupal6/how-create-web-site-handbook/how-setup-mysql/tuning-mysql