diff options
author | Adalbert Michelic <am@timeanddate.com> | 2018-08-02 12:40:07 +0200 |
---|---|---|
committer | Adalbert Michelic <am@timeanddate.com> | 2018-08-02 12:40:07 +0200 |
commit | ae28356a01ff2b727f34c557406ffbb1ac307562 (patch) | |
tree | 256179c32c8752c3992af6ea14b4c7e5ec2d82a8 | |
parent | 68b5b5ed5e75594958d0f3beb0cdcd6609155903 (diff) |
MySQL: add health checks for active connections
-rw-r--r-- | conf.d/health.d/mysql.conf | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/conf.d/health.d/mysql.conf b/conf.d/health.d/mysql.conf index 1eeb993f03..39c401915f 100644 --- a/conf.d/health.d/mysql.conf +++ b/conf.d/health.d/mysql.conf @@ -60,6 +60,21 @@ template: mysql_10s_waited_locks_ratio # ----------------------------------------------------------------------------- +# connections + +template: mysql_connections + on: mysql.connections_active + calc: $active * 100 / $limit + units: % + every: 10s + warn: $this > (($status >= $WARNING) ? (60) : (70)) + crit: $this > (($status == $CRITICAL) ? (80) : (90)) + delay: down 15m multiplier 1.5 max 1h + info: the ratio of current active connections vs the maximum possible number of connections + to: dba + + +# ----------------------------------------------------------------------------- # replication template: mysql_replication |