http://g.raphaelli.com/tags/ganglia/feed.atom 2009-08-07T23:46:46Z Zine tag:g.raphaelli.com,2009-01-05/entry:2009/1/5/mysql-metrics-in-ganglia 2009-08-07T23:46:46Z 2009-01-05T02:43:00Z g <p>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: </p><div style="text-align: center;"><img src="http://static.g.raphaelli.com/images/2009/01/05/ganglia_mysql_report_sample.png" alt="MySQL selects, inserts, updates, deletes on one graph" title="Sample Ganglia MySQL Report"></div> This blog is the only thing using this MySQL server and I don't generate much traffic (hi mom!) <p></p> <p>It works either as a ganglia 3.1-style <a href="http://ganglia.wiki.sourceforge.net/ganglia_gmond_python_modules">gmond python module</a> or as a gmetric script, for use with any decent version of ganglia. These are the relevant files: </p><ul> <li>the module: <a href="http://static.g.raphaelli.com/contrib/code/ganglia/mysql.py">mysql.py</a></li> <li>sample module configuration file: <a href="http://static.g.raphaelli.com/contrib/code/ganglia/mysql.pyconf">mysql.pyconf</a></li> <li>ganglia frontend report: <a href="http://static.g.raphaelli.com/contrib/code/ganglia/mysql_query_report.php">mysql_query_report.php</a></li> <li>dependency module, for parsing InnoDB Status: <a href="http://static.g.raphaelli.com/contrib/code/ganglia/DBUtil.py">DBUtil.py</a></li> </ul> <p></p> Comments and improvements are welcome.