- 论坛徽章:
- 0
|
zabbix-agent客户端脚本如下:
#!/bin/bash
mysql=$(which mysql)
var=$1
MySQL_USER=$2
MySQL_PASSWORD=$3
MySQL_HOST=$4
[ "${MySQL_USER}" == '' ] && MySQL_USER=zabbix
[ "${MySQL_PASSWORD}" == '' ] && MySQL_PASSWORD=zabbix
[ "${MySQL_HOST}" == '' ] && MySQL_HOST=192.168.1.96
[ "${var}" = '' ] && echo "" || ${mysql} -u${MySQL_USER} -p${MySQL_PASSWORD} -h${MySQL_HOST} -e 'show status' | grep -v Variable_name | grep "\b${var}\b" | awk '{print $2}'
然后修改了zabbix_agentd.conf:
UserParameter=mysql.status[*],/etc/zabbix/moniter/moniter-mysql.sh $1
在server端查看日志如下:
1980:20150408:160010.795 item [Slave MySQL:mysql.status[Bytes_sent]] became not supported: Received value [] is not suitable for value type [Numeric (float)]
1980:20150408:160010.796 item [Slave MySQL:mysql.status[Com_begin]] became not supported: Received value [] is not suitable for value type [Numeric (float)]
1980:20150408:160010.797 item [Slave MySQL:mysql.status[Com_commit]] became not supported: Received value [] is not suitable for value type [Numeric (float)],是什么原因呢 |
|