set -x
#!/bin/bash
var=$(mysql -h localhost -u gts -p opengts -e "SELECT count(*) FROM INFORMATION_SCHEMA.PROCESSLIST where time>=1000 and COMMAND='locked'")
#var=$(mysql -e "SELECT count(*) FROM INFORMATION_SCHEMA.PROCESSLIST where time>=100")
vaar=0
con="${var//count(*)}"
echo "$con"
if [ $con -gt $vaar ]
then
   echo "Subject: Mysql query is locked or out of time in Glotrax!" | /usr/sbin/sendmail "srinivas@glovision.co";
#   echo "Subject: Mysql query is locked or out of time in Glotrax!" | /usr/sbin/sendmail "support@glovision.co";
else
   echo "mysql is fine"
fi