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.
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