zabbix脚本监控mysql
mkdir /etc/zabbix/scripts/touch
/etc/zabbix/scripts/chk_mysql.sh
chmod u
+x /etc/zabbix/scripts/chk_mysql.sh
chown
-R zabbix.zabbix /etc/zabbix/scripts/chk_mysql.sh
vim
/etc/zabbix/scripts/chk_mysql.sh
#
!/bin/sh
#
-------------------------------------------------------------------------------
MYSQL_SOCK
="/tmp/mysql.sock"
MYSQL_USER
='zabbix'
MYSQL_PWD
='123456'
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=`/application/mysql/bin/mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -p${MYSQL_PWD} -S $MYSQL_SOCK status|cut -f
2 -d":"|cut -f1 -d"T"`
echo $result
;;
Com_update)
result=`/application/mysql/bin/mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -p${MYSQL_PWD} -S $MYSQL_SOCK extended-
status |grep -w "Com_update"|cut -d"|" -f3`
echo $result
;;
Slow_queries)
result=`/application/mysql/bin/mysqladmin -u$MYSQL_USER -h$MYSQL_HOST -p${MYSQL_PWD} -S $MYSQL_SOCK status |cut -
f5 -d":"|cut -f1 -d"O"`
页:
[1]