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添加分类,项目和触发器
3.查看图形
