Are there any MySQL Benchmarking tools?

Question

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.

Answer 1

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.

For benchmarking, I use Sysbench. Here's an example from my blog.

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.

Answer 2

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 :

http://www.webyog.com/en/monyog_feature_list.php

Answer 3

You can use Spotlight a Toad application

Spotlight® on MySQL diagnoses MySQL problems in real time by graphically displaying all database activity in an intuitive user interface, enabling you to respond quickly to issues that need attention.

Answer 4

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