… 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
Most of the Nagios plugins included with the Percona Monitoring Plugins are purpose-built … you can use for fairly arbitrary checks of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend using it only for two purposes: Check…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly… that ship with Nagios are suitable for checking that the server is alive and responds to a query. The pmp-check-mysql-status is…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… a misunderstanding — perhaps caching was understood to reduce load on MySQL, rather than reducing load on the Cacti server and speeding… for Nagios checks. Why? Exactly the inverse of the two reasons that graphing should be cached! Performance doesn’t matter. First, most Nagios checks…
Post: Announcing MySQL Monitoring Plugins from Percona
February 17, 2012 By 20 Comments
…-class graphing and monitoring for your MySQL servers, using your own on-premises Cacti and Nagios software. The Cacti plugins are derived… the Nagios check plugins are brand new. They are informed by the research we did into the causes and preventions of MySQL downtime… repositories. The new monitoring plugins add first-rate support for MySQL to popular enterprise opensource monitoring systems, and that’s why…
Post: Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities
February 15, 2013 By Leave a Comment
… pmp-check-mysql-status (bug 1048627) * pmp-check-mysql-replication-delay didn’t alert if second behing master is NULL (bug 1040528) * pmp-check-pt… example command for Nagios config: define command{ command_name check_pxc_node_status command_line /usr/lib64/nagios/plugins/pmp-check-mysql-status -l $USER3…
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…
Comment: Announcing MySQL Monitoring Plugins from Percona
February 20, 2012 By 20 Comments
We have been using check_mysql_health (and it’s cousins check_oracle_health, check_mssql_health and check_db2_health) since years and did not see any plugin with a feature list as complete as theirs. http://labs.consol.de/nagios/check_mysql_health/
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… any single node in the cluster. Q: Are adding/updating mysql user accounts replicated? Yes, provided you use CREATE USER or… question about availability of Nagios or other monitoring plugins, and I misspoke: The Percona Monitoring Plugins have a check that enables you…, however, AFAIK, exist any dedicated checks specifically for XtraDB Cluster nodes, or a check that will check cluster consistency across all nodes. Please…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… disk space on /tmp/partition. The first step is clear, check which files are on that partition: # ls -lah /tmp total… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are… partition is limited you should check the free space on it with a monitoring system like Nagios. Trending graphs from Cacti are…
