Surprised I've never stumbled on this before. JetProfiler for monitoring MySQL. Looks very cool. Can't afford the $395 price, but the free version seems helpful enough. Kind of cool that you run it remotely. I have it on my laptop now collecting data from the server.
Wow. This is really helping a lot. Basically it's just running 'show full processlist' every second and compiling the results into some very cool graphs and charts. So it's not doing anything you couldn't do yourself, except the presentation is so easy to grok that it really helps identify bottlenecks. I've already made a few changes based on it that seem to have really sped things up across all my sites.
|
- jim 2-11-2010 8:13 pm
Wow. This is really helping a lot. Basically it's just running 'show full processlist' every second and compiling the results into some very cool graphs and charts. So it's not doing anything you couldn't do yourself, except the presentation is so easy to grok that it really helps identify bottlenecks. I've already made a few changes based on it that seem to have really sped things up across all my sites.
- jim 2-12-2010 6:34 pm