MYSQL之一（监控MYSQL进程、从库状态）

----------------------------------------- SQL进程监控 check_pro.sh ----------------------------------------------------------------------------

#!/bin/bash
#check mysql processlist
#
MYSQLIP=`ifconfig bond1|grep "inet addr" | awk -F[:" "]+ '{print $4}'`
pro_lock=`/usr/bin/mysql -uroot -ppassword -S /disk0/mysql/mysql.sock -e "show processlist"|grep -i "Locked"|wc -l`

if [ ${pro_lock} -gt 10 ]
then
echo "MYSQL $MYSQLIP Porcess too much" | mail -s "MYSQL Porcess too much" [e-mail]
fi

## */10 * * * * /root/shell/check_pro.sh

------------------------------------------ MYSQL从状态监控 check_slave.sh -----------------------------------------------------------
#!/bin/bash
# check mysql slave
#
MYSQLIP=`ifconfig bond1|grep "inet addr" | awk -F[:" "]+ '{print $4}'`

STATUS=`mysql -uroot -ppassword -S /data/mysql/mysql.sock -e "show slave status\G"|grep Running`

IO_STATUS=`echo $STATUS|grep IO|awk '{print $2}'`
SQL_STATUS=`echo $STATUS|grep SQL|awk '{print $2}'`

DT=`date +"%F %T"`

if [ $IO_STATUS = "Yes" -a $SQL_STATUS = "Yes" ]
then
    echo "####### $DT #########" >> /root/shell/check_slave_mysql.log
    echo "Slave is running!" >> /root/shell/check_slave_mysql.log
    echo "Slave is running!"
else
    echo "####### $DT #########" >> /root/shell/check_slave_mysql.log
    echo "Slave is not running!" >> /root/shell/check_slave_mysql.log
    echo "Slave is not running!" | mail -s "warn $HOSTNAME ${MYSQLIP} MySQL Slave is not running" [e-mail]
    echo "Slave is not running!" | mail -s "warn $HOSTNAME ${MYSQLIP} MySQL Slave is not running" [e-mail]
fi

## */30 * * * * /root/shell/check_slave.sh