zabbix監(jiān)控MySQL

qian51

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)]，是什么原因呢

roc-polaris

前端ITEM怎么配置的？數(shù)據(jù)類型是什么？

qingge612

我的也是這個問題。
  5500:20150820:185617.468 error reason for "client19:mysql.status[Com_update]" changed: Received value [] is not suitable for value type [Numeric (float)]

guofzhao

@樓主，這個錯誤已經(jīng)說的很清楚了
item [Slave MySQL:mysql.status[Bytes_sent]] became not supported: Received value [] is not suitable for value type [Numeric (float)]

意思是，你這個item，獲取到的數(shù)據(jù)是[]，沒獲取到正確的數(shù)據(jù)。是監(jiān)控腳本寫的有問題。

xinzhuzhi

zabbix要腳本返回數(shù)值，你這個腳本有問題。

ruochen

用MPM的一套吧

Roarain2

可以用模板監(jiān)控mysql，或者可以用mysqlbix