MySQL monitoring tools

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
markus_petrux's picture
Posted by markus_petrux on September 11, 2006 at 2:18pm

Hi,

Here's a couple of tools that may help in monitoring MySQL performace:

Anyone using similar scripts to monitor high performance mysql servers?

Cheers

Categories: , , ,

Comments

mtop and tuning primer

Posted by kbahey on March 31, 2007 at 3:41am
kbahey's picture

mtop is a very good tool to monitor MySQL in real time.

The tuning primer is also a good tool, but the colors in it annoy me. I have a version which does plain text so it can be piped to a file, ...etc.

Drupal development and consulting 2bits.com
Personal Baheyeldin

Drupal performance tuning, development, customization and consulting: 2bits.com, Inc..
Personal blog: Baheyeldin.com.

mysqlreport

Posted by Amazon on March 31, 2007 at 6:10am
Amazon's picture

I have mysqlreport on a nightly cron.

It's the best summary tool I have found, and it now supports InnoDB analysis.

Kieran

To seek, to strive, to find, and not to yield

New Drupal career! Drupal profile builders.
Try pre-configured and updatable profiles on CivicSpaceOnDemand

DBTuna

Posted by moonparrot on April 8, 2008 at 9:27am
moonparrot's picture

We have DBTuna monitoring several MySQL servers in test and prod.

We've had loads of success with it because you can just keep it running 24x7 and it will show you the over-time resource usage and give you drilldown into what is taking the time.

MySQL enterprise monitor,

Posted by tjholowaychuk on April 8, 2008 at 2:13pm
tjholowaychuk's picture

MySQL enterprise monitor, has anyone tried this solution? I am going to test out the trial soon, I am sure there are comparable open source alternatives but I am interested in trying out more solutions.

vision media
350designs
Print Huge Edmonton Printing Services
Design Inspiration Gallery

Tj Holowaychuk

Vision Media - Victoria BC Web Design
Victoria British Columbia Web Design School

Tried Enterprise monitor on Drupal.org

Posted by Amazon on April 8, 2008 at 2:37pm
Amazon's picture

We tried MySQL Enterprise monitor o Drupal.org. It looked really good. We are working to use it beyond the trial.

Kieran

Drupal community adventure guide, Acquia Inc.
Drupal events, Drupal.org redesign

Maatkit - a few more tools to help admin MySQL

Posted by markus_petrux on May 22, 2008 at 5:16pm
markus_petrux's picture

http://www.maatkit.org/

Cheers