Ganglia for MySQL Metrics
I just made some minor updates to the metric collection module I use for monitoring MySQL with Ganglia. It collects over 100 metrics and includes a basic report like:
It works either as a ganglia 3.1-style gmond python module or as a gmetric script, for use with any decent version of ganglia. These are the relevant files:
- the module: mysql.py
- sample module configuration file: mysql.pyconf
- ganglia frontend report: mysql_query_report.php
- dependency module, for parsing InnoDB Status: DBUtil.py
This looks very cool. Got any plans to add stuff like monitoring various buffer sizes?
Comment by Sean — Jan 6, 2009 1:04:24 AM | #
Over 100 metrics are collected, including InnoDB buffer pool stats, but I haven't produced a report like the one above for them yet. I'm looking at www.xaprb.com/blog/2008/05/25/screenshots-of-improved-mysql-cacti-templates for some report ideas.
Comment by g — Jan 6, 2009 8:43:00 AM | #