zabbix监控mysql

[root@localhost ~]# cp -r /usr/local/zabbix/bin/*  /usr/bin/
[root@localhost ~]# zabbix_get   -s  127.0.0.1 -p 10050 -k system.cpu.load[all,avg15]
0.120000
[root@localhost ~]# mysqladmin -uroot  -h127.0.0.1 ping|grep -c alive
1
[root@localhost ~]# find / -name zabbix_agentd.conf
/root/zabbix-3.4.14/conf/zabbix_agentd.conf
/usr/local/zabbix/etc/zabbix_agentd.conf
/zabbix-3.4.14/conf/zabbix_agentd.conf
[root@localhost ~]# cat /usr/local/zabbix/etc/zabbix_agentd.conf | grep Include
### Option: Include
# Include=
# Include=/usr/local/etc/zabbix_agentd.userparams.conf
Include=/usr/local/etc/zabbix_agentd.conf.d/
# Include=/usr/local/etc/zabbix_agentd.conf.d/*.conf

[root@localhost zabbix]# vim /etc/sysconfig/network-scripts/ifcfg-ens33 
[root@localhost zabbix]# systemctl restart network
[root@localhost zabbix]# ifconfig | head -5
ens34: flags=4099<UP,BROADCAST,MULTICAST>  mtu 1500
        inet 192.168.0.34  netmask 255.255.255.0  broadcast 192.168.0.255
        ether 00:0c:29:1d:c6:6f  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
[root@localhost zabbix]# cat /usr/local/zabbix/etc/zabbix_agentd.conf | grep Server
### Option: Server
#    Example: Server=127.0.0.1,192.168.0.134,192.168.1.0/24,::1,2001:db8::/32,zabbix.domain
# Server=
Server=127.0.0.1,192.168.0.134
### Option: ServerActive
#    Example: ServerActive=192.168.0.134:10051:20051,zabbix.domain,[::1]:30051,::1,[12fc::1]
# ServerActive=
ServerActive=192.168.0.134:10051
#    all collected data to Zabbix Server or Proxy if the buffer is full.
#    Maximum number of new lines the agent will send per second to Zabbix Server
### Option: TLSServerCertIssuer
# TLSServerCertIssuer=
### Option: TLSServerCertSubject
# TLSServerCertSubject=

[root@localhost zabbix_agentd.conf.d]# cat mysql.ping
UserParameter=mysql.ping,mysqladmin -uroot  -h127.0.0.1 ping|grep -c alive

[root@localhost zabbix_agentd.conf.d]# find / -name zabbix_agentd

[root@localhost zabbix_agentd.conf.d]# /etc/rc.d/init.d/zabbix_agentd stop
Stopping zabbix_agentd (via systemctl):                    [  确定  ]
[root@localhost zabbix_agentd.conf.d]# /etc/rc.d/init.d/zabbix_agentd start
Starting zabbix_agentd (via systemctl):                    [  确定  ]

[root@localhost zabbix_agentd.conf.d]# zabbix_get -s 127.0.0.1 -p 10050 -k count.line.passwd
48

[root@localhost zabbix_agentd.conf.d]# cat count.line.passwd 
UserParameter=count.line.passwd,wc -l /etc/passwd | awk '{print $1}'

//重新添加监控项不支持时要删除之前的监控项重新添加

[root@localhost zabbix_agentd.conf.d]# mkdir -p /data/monitor/

[root@localhost zabbix_agentd.conf.d]# vim /data/monitor/mysql_zabbix.sh
[root@localhost zabbix_agentd.conf.d]# chmod +x /data/monitor/mysql_zabbix.sh
[root@localhost zabbix_agentd.conf.d]# cat /data/monitor/mysql_zabbix.sh
#!/bin/bash
MYSQL_PWD=''
ARGS=1
if [ $# -ne "$ARGS" ];then
echo "Please input onearguement:"
fi
case $1 in
Uptime)
result=` mysqladmin  -uroot -p${MYSQL_PWD} status 2>/dev/null|awk '{print $2}'`
echo $result
;;
Questions)
result=`mysqladmin  -uroot -p${MYSQL_PWD} status 2>/dev/null|awk '{print $6}'`
echo $result
;;
Com_update)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_update"|awk '{print $4}'`
echo $result
;;
Slow_queries)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Slow_queries"|awk '{print $4}'`
echo $result
;;
Com_select)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_select"|awk '{print $4}'`
echo $result
;;
Com_rollback)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_rollback"|awk '{print $4}'`
echo $result
;;
Com_insert)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_insert"|awk '{print $4}'`
echo $result
;;
Com_delete)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_delete"|awk '{print $4}'`
echo $result
;;
Com_commit)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_commit"|awk '{print $4}'`
echo $result
;;
Bytes_sent)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Bytes_sent"|awk '{print $4}'`
echo $result
;;
Bytes_received)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Bytes_received"|awk '{print $4}'`
echo $result
;;
Com_begin)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_begin"|awk '{print $4}'`
echo $result
;;
*)
echo "Usage:$0(Uptime|Questions|Com_update|Slow_queries|Com_select|Com_rollback|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin)"
;;
esac

[root@localhost zabbix_agentd.conf.d]# chmod +x zabbix_mysql
[root@localhost zabbix_agentd.conf.d]# cat zabbix_mysql
UserParameter=mysql.status[*],/data/monitor/mysql_zabbix.sh $1

[root@localhost zabbix_agentd.conf.d]# /etc/rc.d/init.d/zabbix_agentd stop
Stopping zabbix_agentd (via systemctl):                    [  确定  ]
[root@localhost zabbix_agentd.conf.d]# /etc/rc.d/init.d/zabbix_agentd start
Starting zabbix_agentd (via systemctl):                    [  确定  ]
[root@localhost zabbix_agentd.conf.d]# zabbix_get  -s   127.0.0.1  -k   mysql.status[Com_select]
3888

[root@localhost zabbix_agentd.conf.d]# zabbix_get  -s   127.0.0.1  -k   mysql.status[Com_select]
56107
[root@localhost zabbix_agentd.conf.d]# cat zabbix_mysql 
UserParameter=mysql.status[*],/data/monitor/mysql_zabbix.sh $1
[root@localhost zabbix_agentd.conf.d]# cat /data/monitor/mysql_zabbix.sh | grep select
Com_select)
result=`mysqladmin  -uroot -p${MYSQL_PWD} extended-status 2>/dev/null|grep -w "Com_select"|awk '{print $4}'`
echo "Usage:$0(Uptime|Questions|Com_update|Slow_queries|Com_select|Com_rollback|Com_insert|Com_delete|Com_commit|Bytes_sent|Bytes_received|Com_begin)"