#!/bin/bash

SERVERS='/root/bin/mysqlservers'
USER='username'
PASS='password'
ALERTEMAIL='blacknight@uptime.blacknight.ie'

for i in `cat $SERVERS`;
do
	SERVER=`echo $i | sed -e 's/:.*$//'`
	echo Server: $SERVER
	THRESHOLD=`echo $i | sed -e 's/^.*://'`
	echo Threshold: $THRESHOLD
	CURRENT=`mysqladmin -h $SERVER -u$USER -p$PASS processlist | wc -l`
	echo Current: $CURRENT
	if [ $CURRENT -gt $THRESHOLD ]
	then
		 mysqladmin -h $SERVER -u$USER -p$PASS processlist | awk '{print $8}' | grep _ | sort | uniq -c | sort -k1 -n -r | head -n 20 | mail -s "[ALERT] ${SERVER} has ${CURRENT} mysql processes. Threshold: ${THRESHOLD}" -a 'From: alert@blacknight.ie' -a "X-Source: $0 on `hostname -f`" $ALERTEMAIL
		echo Alert sent for $SERVER
	fi
	echo ---------------------------
done