检查数据库服务器负载，发送负载高时的SQL语句

#monitor database server load and send mail
#!/bin/bash
function Send_Email()
{
ADMIN="[e-mail]"
MESSAGE_FILE="/tmp/db_load_monitor.log"
echo "Database server load is high as `date`,please check it!" > $MESSAGE_FILE
echo "================================================================================================" >> $MESSAGE_FILE
mysql -uroot -p123 -e 'show full processlist' >>$MESSAGE_FILE
        /bin/mail -s "Database server load is high,please check it." $ADMIN < $MESSAGE_FILE
rm -r $MESSAGE_FILE
}


CPU_NUMBER=`cat /proc/cpuinfo |grep processor |wc -l`
#MAX_LOAD=`echo $CPU_NUMBER*2|bc`
MAX_LOAD=5
LOAD=`uptime | cut -d":" -f 5|cut -d"," -f 1`
   if [ `echo "$LOAD > $MAX_LOAD" | bc` = 1 ]
   then
       Send_Email
   fi