1.写监控服务的脚本

[root@db02 ~]# cat mysqlstat.sh
#!/bin/bash

mysqlstat=`ps aux | grep mysql | wc -l`
echo $mysqlstat
[root@db02 ~]# ./mysqlstat.sh
3

[root@db02 ~]# snmpwalk -v 2c -c public localhost .1.3.6.1.2.1.1.9.1.4.100
SNMPv2-MIB::sysORUpTime.100 = No Such Instance currently exists at this OID
[root@db02 ~]# vim /etc/snmp/snmpd.conf
extend .1.3.6.1.2.1.1.9.1.4.100  mysqlstat /root/mysqlstat.sh    #添加一行

[root@db02 ~]# /etc/init.d/snmpd restart
Stopping snmpd:                               [  OK  ]
Starting snmpd:                                 [  OK  ]
[root@db02 ~]# snmpwalk -v 2c -c public localhost -On  .1.3.6.1.2.1.1.9.1.4.100
.1.3.6.1.2.1.1.9.1.4.100.1.0 = Wrong Type (should be Timeticks): INTEGER: 1
.1.3.6.1.2.1.1.9.1.4.100.2.1.2.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): STRING: "/root/mysqlstat.sh"
.1.3.6.1.2.1.1.9.1.4.100.2.1.3.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): ""
.1.3.6.1.2.1.1.9.1.4.100.2.1.4.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): ""
.1.3.6.1.2.1.1.9.1.4.100.2.1.5.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 5
.1.3.6.1.2.1.1.9.1.4.100.2.1.6.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 1
.1.3.6.1.2.1.1.9.1.4.100.2.1.7.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 1
.1.3.6.1.2.1.1.9.1.4.100.2.1.20.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 4
.1.3.6.1.2.1.1.9.1.4.100.2.1.21.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 1
.1.3.6.1.2.1.1.9.1.4.100.3.1.1.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): STRING: "5"
.1.3.6.1.2.1.1.9.1.4.100.3.1.2.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): STRING: "5"
.1.3.6.1.2.1.1.9.1.4.100.3.1.3.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 1
.1.3.6.1.2.1.1.9.1.4.100.3.1.4.9.109.121.115.113.108.115.116.97.116 = Wrong Type (should be Timeticks): INTEGER: 0
.1.3.6.1.2.1.1.9.1.4.100.4.1.2.9.109.121.115.113.108.115.116.97.116.1 = Wrong Type (should be Timeticks): STRING: "5"
[root@db02 ~]#


2.在zabbix添加分类,项目和触发器

wKioL1ce4j6yVwD8AABtSmbEiXI148.png

wKiom1ce4gvA9LGPAAA81rafOrY217.png

wKioL1ce4tWjadDkAABcw2Tb0L4882.png


3.查看图形

wKiom1ce4m2wY-hMAAA2bpQTMMY821.png