zabbix --监控mysql增删改查 （三）

1，将监控项写进脚本

[root@kafka01 ~] vim /etc/zabbix/scripts/check_mysql.sh
[root@kafka01 ~] cat /etc/zabbix/scripts/check_mysql.sh 
#!/bin/bash
case $1 in
	slave_status)
	mysql -uchecke -p123 -e "show slave status \G;" | grep 'Running' | grep "Yes" |wc -l
	;;
	Bytes_sent) #发送流量
	mysqladmin extended-status |grep "Bytes_sent"|awk '{print $4}'
	;;
	Bytes_received)	#接受流量
	mysqladmin extended-status | grep 'Bytes_received'|awk '{print $4}'
	;;
	Com_insert) #增加插入数据
	mysqladmin extended-status |grep -w "Com_insert"|awk '{print $4}'
	;;
	Com_delete) #删除数据
	mysqladmin extended-status |grep -w "Com_delete"|awk '{print $4}'
	;;
	Com_update) #修改数据
	mysqladmin extended-status |grep -w "Com_update"|awk '{print $4}'
	;;
	Com_select) #查看数据
	mysqladmin extended-status |grep -w "Com_select"|awk '{print $4}'
	;;
	Com_commit) #数据回滚
	mysqladmin extended-status |grep -w "Com_commit"|awk '{print $4}'
	;;
	Com_rollback) #数据提交
	mysqladmin extended-status |grep -w "Com_rollback"|awk '{print $4}'
	;;
esac