From 2db3a2a6be414cfdb12fc63b81d9c07394cb379c Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@helsinki.at>
Date: Tue, 28 Jul 2015 04:43:51 +0200
Subject: added perfdata for mysql_repl


diff --git a/checks/mysql_repl b/checks/mysql_repl
index 372eeb5..a5aa0bf 100644
--- a/checks/mysql_repl
+++ b/checks/mysql_repl
@@ -24,14 +24,22 @@ def inventory_mysql_repl_status(info):
    except Exception, e:
       return []
 
+
+def str2float(str):
+   try:
+      return float(str)
+   except ValueError:
+      return 0.0
+
 def check_mysql_repl_status(item, params, info):
    try:
       values = extract_values(info)
+      perfdata = [ ("Seconds_Behind_Master", str2float(values['Seconds_Behind_Master']), 5, 10, "", "") ]
       if item in values:
          if values[item] == 'Yes':
-            return (OK, 'Slave %s is running' % params[0])
+            return (OK, 'Slave %s is running' % params[0], perfdata)
 
-      return (CRIT, 'Slave %s is not(!!) running' % params[0])
+      return (CRIT, 'Slave %s is not(!!) running: %s' % (params[0], values['Last_%s_Error' % params[0]]), perfdata)
 
    except Exception, e:
       return (UNKNOWN, "mysql_repl check failed: %", e.message)
@@ -41,5 +49,6 @@ check_info["mysql_repl"] = {
     'check_function':            check_mysql_repl_status,
     'inventory_function':        inventory_mysql_repl_status,
     'service_description':       'mySQL Replication CLient Status',
+    'has_perfdata':              True,
 }
 
-- 
cgit v0.10.2