Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

4 Answers

up vote 6 down vote accepted

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.

share|improve this answer
    
Sysbench would be a viable solution , mybench ( perls script ) would be too , however i'm more intrested in a tool that let's me know what settings should be tweeked as i'm not a DBA . –  poelinca Jan 3 '11 at 22:25
    
Adding to my answer. –  randy melder Jan 3 '11 at 22:40
add comment

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.

enter image description here 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

share|improve this answer
add comment

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.

share|improve this answer
    
quote from spotlight site: " ... With Spotlight on MySQL, DBAs or developers running Windows ... " , not realy suited as most web based app databases are on unix systems . –  poelinca Jan 4 '11 at 8:49
    
@poelinca - my bad! I think you should re-phrase your post to get more accurate information... –  Coder Hawk Jan 4 '11 at 9:05
1  
@poelinca: The target for Spotlight can be on any platform - Spotlight itself runs on Windows. We have TOAD running on Windows against Linux and Solaris DBs, no problems. –  Gaius Jan 15 '11 at 16:46
    
@Gaius: realy helpfull to know this, but in my case i would have to run it from my girlfriend pc ? , i don't own a pc/notebook/netbook that has windows installed . –  poelinca Jan 16 '11 at 9:27
    
Or run it in a VM or whatever. Is the cost of not fixing your problem greater than the cost of the tools and time to fix it, is the only question. –  Gaius Jan 16 '11 at 11:18
add comment

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

share|improve this answer
    
Can you explain the mechanics of the test? How do we interpret it? A simple link to the community isn't very useful. –  Brian Ballsun-Stanton Jan 11 '11 at 12:44
add comment

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.