snmpを利用したMySQLの監視

MySQL状態取得用のシェルを追加
# vi /usr/local/libexec/mysql_threads_connected.sh

#!/bin/sh
echo "show status" | mysql -u root -h localhost | grep Threads_connected | awk '{print $1}'
var=`echo "show status" | mysql -u root -h localhost | grep Threads_connected | awk '{print $2}'`
exit $var

/etc/snmp/snmpd.confに以下を追加
# vi /etc/snmp/snmpd.conf
exec .1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100 mysql usr/local/libexec/mysql_threads_connected.sh

サービスの再読み込み
# service snmpd reload

MIB情報を取得し確認
snmpwalk -c public -v 2c localhost .1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100

• • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • -

.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.1.1 = Wrong Type (should be OCTET STRING): INTEGER: 1
.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.2.1 = STRING: mysql
.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.3.1 = STRING: usr/local/libexec/mysql_threads_connected.sh
.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.100.1 = Wrong Type (should be OCTET STRING): INTEGER: 11
.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.101.1 = STRING: Threads_connected
.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.102.1 = Wrong Type (should be OCTET STRING): INTEGER: 0
.1.3.6.1.4.1.8072.1.3.2.4.1.2.6.109.121.115.113.108.100.103.1 = STRING:

• • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • -

snmpd.confとシェルの組み合わせでいろんなものがとれるかも。
zabbix・hinemosなんかと組み合わせるとsnmpで監視できます。