root@gongdan:[/root]cat /server/scripts/chk_DB.sh
#!/bin/bash
#filename:chk_DB.sh
#date:2017/08/11
#auth:xusx
#xushaoxin@centrin.com.cn
MYSQL_SOCK=''
MYSQL_USER=''
MYSQL_PASSWD=''
MYSQL_HOST='127.0.0.1'
MYSQL_PORT='3306'
ARGS=1
if [ $# -ne $ARGS ];then
echo "please input one arguement"
fi
case $1 in
Uptime)
result=`/usr/bin/mysqladmin -u$MYSQL_USER -p$MYSQL_PASSWD status 2>/dev/null | cut -f2 -d":"|cut -f1 -d"T"`
echo $result
;;
Threads)
result=`/usr/bin/mysqladmin -u$MYSQL_USER -p$MYSQL_PASSWD status 2>/dev/null | cut -f3 -d":"|cut -f1 -d"Q"`
echo $result
;;
Questions)
result=`/usr/bin/mysqladmin -u$MYSQL_USER -p$MYSQL_PASSWD status 2>/dev/null | cut -f4 -d":"|cut -f1 -d"S"`
echo $result
;;
Slow_queries)
result=`/usr/bin/mysqladmin -u$MYSQL_USER -p$MYSQL_PASSWD status 2>/dev/null | cut -f5 -d":"|cut -f1 -d"O"`
echo $result
;;
*)
echo "Usage:$0(Uptime|Threads|Questions|Slow_queries)"
;;
esac