Алерт при всплеске медленных запросов MySQL

#!/usr/bin/env bash
# Count slow queries logged in the last 60 seconds. Alert above THRESHOLD.
LOG="/var/log/mysql/mysql-slow.log"
THRESHOLD=${THRESHOLD:-20}

SINCE=$(date -u -d "1 minute ago" "+%Y-%m-%dT%H:%M")
COUNT=$(awk -v t="$SINCE" '
  /^# Time:/ { ts = substr($3 " " $4, 1, 16) }
  /^# Query_time/ && ts >= t { c++ }
  END { print c+0 }
' "$LOG")

if [ "$COUNT" -gt "$THRESHOLD" ]; then
  curl -X POST "$SLACK_WEBHOOK" \
    --data "{\"text\":\"MySQL: $COUNT slow queries in the last minute (threshold $THRESHOLD)\"}"
fi