[MySQL]: Long running query stopper shell script & alerting mechanism

#!/bin/bash > /home/srinivas/MySQL_Long_Query_Kill.log RECIPIENT=srinivas@dbversity.com,santhosh@dbversity.com RECIPIENTCC=test@dbversity.com RECIPIENTBCC=dbversity@gmail.com SEC=700 IFS=’|’ if [[ $SEC -lt 700 ]]; then echo “Usage: All the MySQL queries are less than $SEC seconds, So no MySQL process to Kill ….” exit 1 fi mysqladmin proc -v|grep Query|grep…