…, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… its polling processes serially, so if each graph has to reach out to the MySQL server and retrieve a bunch of data…’ve seen cases where a Cacti server that’s graphing too many MySQL servers doesn’t finish the current iteration before the… for Nagios checks. Why? Exactly the inverse of the two reasons that graphing should be cached! Performance doesn’t matter. First, most Nagios…
Post: Announcing MySQL Monitoring Plugins from Percona
February 17, 2012 By 20 Comments
… plugins for MySQL servers and related software. With these plugins, you can set up world-class graphing and monitoring for your MySQL servers, using your own on-premises Cacti and Nagios software. The Cacti plugins… the Nagios check plugins are brand new. They are informed by the research we did into the causes and preventions of MySQL…
Post: Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities
February 15, 2013 By Leave a Comment
….0.2 — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring… command for Nagios config: define command{ command_name check_pxc_node_status command_line /usr/lib64/nagios/plugins/pmp-check-mysql-status -l…
Post: What’s a good buffer pool read/write ratio?
May 31, 2011 By 6 Comments
… whether systems are healthy. So, why graph them, then? First, let me say that the graph actually doesn’t show a ratio… the graphs for diagnosing problems that you already know about, not for trying to discover problems. Your monitoring and alerting system (Nagios?) should be trying to discover whether there is a problem. The graphs are there for quickly showing…
Comment: Tools
June 2, 2008 By 31 Comments
…/ If you use Nagios, there is this plugin : http://www.consol.com/opensource/nagios/check-mysql-perf/ And with rrdtool (n2rrd + nagios + rrdtool) you can do some good graphs 
http://img91.imageshack.us…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are… the free space on it with a monitoring system like Nagios. Trending graphs from Cacti are also a very good option to…
Post: Release 1.0.1 of Percona Monitoring Plugins
June 15, 2012 By 1 Comment
… Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring… designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates…
