prevent notifications flood from mysql alarms

diff --git a/conf.d/health.d/mysql.conf b/conf.d/health.d/mysql.conf
index e6f309fe8702e7a101f28044462289b06215ca3d..78773e5b5b0b141489d334cbdbaf0b5bbe535b11 100644 (file)
--- a/conf.d/health.d/mysql.conf
+++ b/conf.d/health.d/mysql.conf
@@ -49,15 +49,16 @@ template: mysql_10s_table_locks_waited
 
 template: mysql_10s_waited_locks_ratio
       on: mysql.table_locks
-    calc: $mysql_10s_table_locks_waited * 100 / ( $mysql_10s_table_locks_waited + $mysql_10s_table_locks_immediate)
+    calc: ($mysql_10s_table_locks_waited * 100) / ($mysql_10s_table_locks_waited + $mysql_10s_table_locks_immediate)
    units: %
    every: 10s
-    warn: $this > (($status >= $WARNING)  ? (10) : (20))
-    crit: $this > (($status == $CRITICAL) ? (20) : (50))
-   delay: down 5m multiplier 1.5 max 1h
+    warn: $this > (($status >= $WARNING)  ? (10) : (25))
+    crit: $this > (($status == $CRITICAL) ? (25) : (50))
+   delay: down 30m multiplier 1.5 max 1h
     info: the ratio of mysql waited table locks, for the last 10 seconds
       to: dba
 
+
 # -----------------------------------------------------------------------------
 # replication
 
@@ -78,7 +79,7 @@ template: mysql_replication_lag
    every: 10s
     warn: $this > (($status >= $WARNING)  ? (5)  : (10))
     crit: $this > (($status == $CRITICAL) ? (10) : (30))
-   delay: down 5m multiplier 1.5 max 1h
+   delay: down 15m multiplier 1.5 max 1h
     info: the number of seconds mysql replication is behind this master
       to: dba