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 already have system availability monitoring for all my MySQL instances in Nagios. I'm looking to get some trending monitoring going for activity. It'd be nice to see how all the information_schema stats trend over time, to help identify sources of problems etc.

I've seen Cacti exists and seems pretty popular.

What have your experiences with Cacti been (pros/cons)?

Are there any other common solutions I should investigate?

share|improve this question
add comment

6 Answers

If you're looking for graphs, Cacti (or Munin) will work. I've personally only used Munin.

However, I wouldn't put much stock in graphs to troubleshoot problems that arise. If it's showing in the graphs, it's been going on too long.

I would get familiar with the maatkit or percona tools (I think percona is a fork of maatkit) for trouble shooting problems.

share|improve this answer
    
I disagree they can't help trouble shoot at all, but I do agree they would just serve as the tip of the ice berg inidicating something you didn't have an alarm set for needs investigating. I do use percona tool kit, it's proven quite handy. Another thing I'm looking for in graphs is helping prove a change helpded fix or improve something. –  atxdba Sep 30 '11 at 2:05
add comment

If you are looking for a tool to monitor both MySQL and Linux box you can always trust MONyog. It has decent looking Dashboard charts and also you can generate trend reports and lots more.

IMHO: comparing with Cacti or Nagios, MONyog has easy customization features and you would also not need to configure your http servers as MONyog has its own.

share|improve this answer
    
I gave MONyog a once over. I didn't see any compelling reason to go w/ MONyog over open source –  atxdba Oct 21 '11 at 20:25
add comment

I wrote a daemon that logs the results of SHOW GLOBAL STATUS and SHOW MUTEX STATUS every x seconds to graphite or a CSV. You may find it useful: https://github.com/9minutesnooze/mysampler. It can provide you insight into all the MySQL status information at whatever granularity you choose. There isn't any documentation yet, but I have found the output highly useful, either by pulling the CSV into gnuplot or (better) viewing the results in graphite to correlate with other metrics. I plan on extending it soon to parse SHOW ENGINE INNODB STATUS as well. I'm sure there is other data from INFORMATION_SCHEMA that would be valuable to add in, but I haven't gotten there yet.

For slightly less granular and more processed results, the Percona Cacti Templates are very good, but only show problems that have existed for a "long" time. They do show some interesting trending information and, as with most charts and graphs, the differences over time are what tend to be most enlightening.

share|improve this answer
add comment

If you only want to see live, customizable trending graphs over the past 2-5 minutes, you should use MySQL Administrator. Believe it or not, although it went EOL December 18, 2009, the last version of MySQL Administrator is still available for download for free. Hey, I still it them today.

Click here and get it while Oracle isn't looking ... QUICK !!!

share|improve this answer
    
@Mat I updated the link. Thank You !!! –  RolandoMySQLDBA Mar 9 '13 at 22:20
add comment

Jet Profiler is great for monitoring MySQL. Works like SQL Server profiler, but it includes graphs and charts.

http://www.jetprofiler.com/

share|improve this answer
add comment

There are open source tools from Percona. Try pt-mysql-summary and pt-variable-advisor.

If you are looking for a commercial tool, try MONyog -MySQL Monitor, which has 600+ monitors and an advisor to fine-tune your MySQL server.

screen shot

share|improve this answer
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.