From 866afd4be1f8a02b0a859047bf2ad8c7f2a8c054 Mon Sep 17 00:00:00 2001
From: "Costa Tsaousis (ktsaou)" <costa@tsaousis.gr>
Date: Mon, 5 Sep 2016 23:20:09 +0300
Subject: [PATCH] network interface errors are now warnings; added mysql alarm

---
 conf.d/Makefile.am         |  1 +
 conf.d/health.d/mysql.conf | 12 ++++++++++++
 conf.d/health.d/net.conf   |  4 ++--
 3 files changed, 15 insertions(+), 2 deletions(-)
 create mode 100644 conf.d/health.d/mysql.conf

diff --git a/conf.d/Makefile.am b/conf.d/Makefile.am
index c2fbac5a..4dff0387 100644
--- a/conf.d/Makefile.am
+++ b/conf.d/Makefile.am
@@ -47,6 +47,7 @@ dist_healthconfig_DATA = \
 	health.d/disks.conf \
 	health.d/entropy.conf \
 	health.d/memcached.conf \
+	health.d/mysql.conf \
 	health.d/named.conf \
 	health.d/net.conf \
 	health.d/nginx.conf \
diff --git a/conf.d/health.d/mysql.conf b/conf.d/health.d/mysql.conf
new file mode 100644
index 00000000..77c21aa0
--- /dev/null
+++ b/conf.d/health.d/mysql.conf
@@ -0,0 +1,12 @@
+
+# make sure mysql is running
+
+template: mysql_last_collected_secs
+      on: mysql.queries
+    calc: $now - $last_collected_t
+   every: 10s
+    warn: $this > ( 5 * $update_every)
+    crit: $this > (60 * $update_every)
+   units: seconds ago
+    info: number of seconds since the last successful data collection
+      to: dba
diff --git a/conf.d/health.d/net.conf b/conf.d/health.d/net.conf
index 209dbda6..8ed71375 100644
--- a/conf.d/health.d/net.conf
+++ b/conf.d/health.d/net.conf
@@ -7,7 +7,7 @@ template: 30min_packet_drops
       on: net.drops
   lookup: sum -30m unaligned absolute
    every: 1m
-    crit: $this > 0
+    warn: $this > 0
    units: packets
     info: dropped packets in the last 30 minutes
       to: sysadmin
@@ -22,7 +22,7 @@ template: 30min_fifo_errors
       on: net.fifo
   lookup: sum -30m unaligned absolute
    every: 1m
-    crit: $this > 0
+    warn: $this > 0
    units: errors
     info: network interface fifo errors in the last 30 minutes
       to: sysadmin
-- 
2.39.2