zabbix配置监控mysql
#!/bin/bash#Create by zhengdazhi 2014.09.22
MYSQL_DIR=/usr/local/mysql
MYSQL=${MYSQL_DIR}/bin/mysql
MYSQLADMIN=${MYSQL_DIR}/bin/mysqladmin
MYSQL_SOCK="/tmp/mysql.sock"
MYSQL_USER=root
MYSQL_PWD=root
ARGS=1
if[ $# -ne "$ARGS" ];then
echo"Please input one arguement:"
fi
case$1 in
Uptime)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK status|cut-f2 -d":"|cut-f1 -d"T"`
echo$result
;;
Com_update)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_update"|cut-d"|"-f3`
echo$result
;;
Slow_queries)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK status |cut-f5 -d":"|cut-f1 -d"O"`
echo$result
;;
Com_select)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_select"|cut-d"|"-f3`
echo$result
;;
Com_rollback)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_rollback"|cut-d"|"-f3`
echo$result
;;
Questions)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK status|cut-f4 -d":"|cut-f1 -d"S"`
echo$result
;;
Com_insert)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_insert"|cut-d"|"-f3`
echo$result
;;
Com_delete)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_delete"|cut-d"|"-f3`
echo$result
;;
Com_commit)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_commit"|cut-d"|"-f3`
echo$result
;;
Bytes_sent)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Bytes_sent"|cut-d"|"-f3`
echo$result
;;
Bytes_received)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Bytes_received"|cut-d"|"-f3`
echo$result
;;
Com_begin)
result=`${MYSQLADMIN} -u${MYSQL_USER} -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status |grep-w "Com_begin"|cut-d"|"-f3`
echo$result
;;
*)
echo"Usage:$0(Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions)"
;;
esac
14864612.65844
页:
[1]