up vote 8 down vote favorite
2
share [g+] share [fb]

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.

link|improve this question
feedback

4 Answers

up vote 3 down vote

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.

link|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
feedback
up vote 2 down vote

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.

link|improve this answer
feedback
up vote 2 down vote

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.

link|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... – Sandy 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
feedback
up vote 2 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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