《Centos7——zabbix监控mysql的常规操作》
《Centos7——zabbix监控mysql的常规操作》
http://blog.csdn.net/weixin_45842014/article/details/108723881
192.168.179.131(客户端)
vim /etc/zabbix/zabbix_agentd.d/myql_status.conf
UserParameter=mysql_status[*],/etc/zabbix/scripts/mysql_status.sh $1
vim /etc/zabbix/scripts/mysql_status.sh
#!/bin/bash
mysql="mysql -ucheck -p123 -h 192.168.179.131"
case $1 in
slave_status)
mysql -e "show slave status\G;"|grep -w Yes|awk '{print $2}'|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)
;;
db_size)
$mysql -e "select sum(data_length) from information_schema.tables where table_schema='mysql';"|sed -n "2p"
;;
tb_size)
$mysql -e "select sum(data_length) from information_schema.tables where table_schema='mysql' and table_name='user';"|awk 'NR==2'
;;
esac
服务端
yum -y install zabbix-get
《Centos7——zabbix监控mysql的常规操作》相关教程