Zabbix监控mysql配置文档.docxVIP

监控配置文档1、基本信息目标机器：91监控服务器：52、监控项Mysql数据目录监控项说明脚本FreeSpaceForMysql供给Mysql的空间大小df -m /var/lib/mysql/mysql | tail -1 | awk {print $3}Mysql实时连接情况监控项说明脚本mysql.versionMysql版本mysql -Vmysql.pingMysql是否在提供服务mysqladmin -uroot -proot -S /var/lib/mysql/mysql.sock ping | grep -c alivemysql.statusMysql的状态信息/usr/local/zabbix/scripts/mysqlstatus.sh $1 $2MySqlConnectsMysql的连接数mysql -uroot -proot -BNe select count(h ost) from processlist; information_schema3、Agent端配置将上述监控选项和获取值的脚本写入Zabbix_Agent的配置文件中。打开zabbix_agentd.conf文件:vi /usr/local/zabbix/etc/zabbix_agentd.conf更改配置如下：更改：Server=5更改：HostName=191DB注释掉：ServerActive=5添加：UserParameter=mysql.version,mysql -VUserParameter=mysql.ping,mysqladmin -uroot -proot -S /var/lib/mysql/mysql.sock ping 2/dev/null| grep -c aliveUserParameter=mysql.status[*],/usr/local/zabbix/scripts/mysqlstatus.sh $1 $2UserParameter=FreeSpaceForMysql,df -m /data/mysql | tail -1 | awk {print $3}UserParameter=SpaceOfMysql,df -m /data/mysql | tail -1 | awk {print $2}UserParameter=MySqlConnects,mysql -uroot -proot -BNe select count(host) from processlist; information_schema 2/dev/null在/usr/local/zabbix/下新建文件夹scripts，再在文件夹下新建脚本mysqlstatus.sh，脚本内容如下：# cat checkmysqlperformance.sh#!/bin/sh#Create by Jason 2015.07.02MYSQL_SOCK=/var/lib/mysql/mysql.sockMYSQL_PWD=rootARGS=1if [ $# -ne $ARGS ];then echo Please input one arguement:ficase $1 in Uptime) result=`mysqladmin -u root -p${MYSQL_PWD} -S $MYSQL_SOCK status 2/dev/null |cut -f2 -d:|cut -f1 -dT` echo $result ;;Com_update) result=`mysqladmin -u root -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status 2/dev/null |grep -w Com_update|cut -d| -f3` echo $result ;;Slow_queries) result=`mysqladmin -u root -p${MYSQL_PWD} -S $MYSQL_SOCK status 2/dev/null |cut -f5 -d:|cut -f1 -dO` echo $result ;;Com_select) result=`mysqladmin -u root -p${MYSQL_PWD} -S $MYSQL_SOCK extended-status 2/dev/null |grep -w Com_select|c