zabbix监控MySQL数据库的参数直接可用

zabbix监控MySQL数据库的参数直接可用

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