|
本帖最后由 dinggel 于 2016-3-8 16:11 编辑
zabbix_agentd.conf:
UnsafeUserParameters=1
UserParameter=mysql.ping,HOME=/usr/local/zabbix-2.4.7/etc/zabbix_agentd.conf.d mysqladmin -S /data/mysql_data_3306/mysql.sock ping |grep -c alive
UserParameter=mysql.version,mysql -V
UserParameter=mysql.status,/usr/local/zabbix-2.4.7/alertscripts/checkmysqlperformance.sh $1
checkmysqlperformance.sh:
MYSQL_SOCK="/data/mysql_data_3306/mysql.sock"
ARGS=1
USER=zabbixuser
MYPATH=/usr/local/mysql/bin
if [ $# -ne "$ARGS" ];then
echo "Please input one arguement:"
fi
case $1 in
Uptime)
result=`$MYPATH/mysqladmin -u$USER -S $MYSQL_SOCK status |cut -f2 -d":"|cut -f1 -d"T"`
echo $result
;;
Com_update)
result=`$MYPATH/mysqladmin -u$USER -S $MYSQL_SOCK extended-status |grep -w "Com_update"|cut -d"|" -f3`
echo $result
;;
Slow_queries)
result=`$MYPATH/mysqladmin -u$USER -S $MYSQL_SOCK status |cut -f5 -d":"|cut -f1 -d"O"`
echo $result
;;
my.cnf:
[client]
user=zabbixuser
password=zabbix....
运行如下:
[iyunv@java zabbix-2.4.7]# /usr/local/zabbix-2.4.7/bin/zabbix_get -s 192.168.1.10 -k mysql.ping
[iyunv@java zabbix-2.4.7]# mysqladmin -S /data/mysql_data_3306/mysql.sock ping |grep -c alive
1
zabbix web上是这样
这个问题在百度google找了好久 都没解决,请问有人能帮我看下吗?线上等帮助 谢谢
|
|