mysql .sh_mysql_check.sh

#!/bin/sh

#====================================

# $Name: mysql_check.sh

# $Revision: 1.0

# $Function: This Nagios plugin can be check MySQL status

# $Author: Shundong Zhao

# $organization: UnixHot

# $Create Date: 2010-08-10

#===================================

MYSQLC="/usr/local/mysql/bin/mysql"

MYSQLADC="/usr/local/mysql/bin/mysqladmin"

MUSER="nagios"

MPASSWD="nagios"

SLOWLOGW="2"

STATE_OK=0

STATE_WARNING=1

STATE_CRITICAL=2

STATE_UNKNOWN=3

mysqlstatus(){

STATUSSTR=`$MYSQLADC -u $MUSER -p$MPASSWD ping`

if [ "$STATUSSTR" == "mysqld is alive" ];then

echo -n "$STATUSSTR";

return 0;

else

echo -n "$STATUSSTR";

exit 2;

fi

}

mysqlslowlog(){

SLOWLOGTMP=`$MYSQLADC -u $MUSER -p$MPASSWD status`

SLOWLOGNU=`echo $SLOWLOGTMP | awk -F ' ' '{print $9}'`

if [ "$SLOWLOGNU" -gt "$SLOWLOGW" ];then

echo -n "Slow queries:$SLOWLOGNU";

exit 2;

else

echo -n "Slow Querite:$SLOWLOGNU";

fi

}

main(){

mysqlstatus;

echo -n ";";

#mysqlreplication;

mysqlslowlog;

}

main