linux中MySQL监控脚本方法介绍

[root@oldboy scripts]# cat check_db01.sh
#!/bin/sh
#created by oldboy
#mail:[email protected]
PortNum=`netstat -lnt|grep 3306|wc -l`
if [ $PortNum -eq 1 ]
then
echo "mysqld is running."
else
echo "mysqld is stoped."
fi

#!/bin/sh
MailList="[email protected]"

DBDataDir="/usr/local/mysql/var"

DBPort="3306"

IP=`ifconfig | grep 'inet addr:' -m 1 | grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}'`;

ErrFile="$DBDataDir/$HOSTNAME.err"

ErrLine=`cat $ErrFile | wc -l`

GetDate=`date '+%Y-%m-%d %H:%M:%S'`
if [ ! -e /tmp/dberrline$DBPort ]
then
echo "$ErrLine" >/tmp/dberrline$DBPort
echo "Run it first!"
exit
fi

OldLine=`cat /tmp/dberrline$DBPort`
echo "$ErrLine" >/tmp/dberrline$DBPort

if [ "$ErrLine" -gt "$OldLine" ]
then

TailLine=`expr $ErrLine - $OldLine`
ErrStr=`tail -$TailLine "$ErrFile"`

LeftStr=`echo "$ErrStr" | sed '/InnoDB: ERROR: the age of the last checkpoint is/d' | sed '/InnoDB: which exceeds the log group capacity/d' |sed '/InnoDB: If you are using big BLOB or TEXT rows, you must set the/d' | sed '/InnoDB: combined size of log files at least 10 times bigger than the/d' | sed '/InnoDB: largest such row./d'`

if [ "$LeftStr" != "" ]
then
echo "$LeftStr" |mutt -s "Something wrong with $HOSTNAME-$IP($DBPort)!" ${MailList}
echo "$LeftStr"
fi
fi