zabbix自定义监控mysql_zabbix自定义监控mysql

最新推荐文章于 2023-04-13 16:14:47 发布

车缘阁

最新推荐文章于 2023-04-13 16:14:47 发布

阅读量213

点赞数

文章标签： zabbix自定义监控mysql

本文链接：https://blog.csdn.net/weixin_30949015/article/details/113689949

版权

创建用户：

use mysql;

grant all privileges on *.* to 'zabbix'@'%' identified by 'zabbixpasswd';

grant all privileges on *.* to 'zabbix'@'localhost' identified by 'zabbixpasswd';

flush privileges;

修改 /etc/zabbix/zabbix_agentd.conf

Include=/etc/zabbix/zabbix_agentd.d/*.conf

vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

UserParameter=mysql.alive,/usr/local/mysql/bin/mysqladmin ping 2>/dev/null |grep -c "alive"

UserParameter=mysql.processlist_count,/usr/local/mysql/bin/mysql -e "select count(*) from information_schema.processlist where command !='Sleep' " |grep -v "count"

UserParameter=mysql.Slave_IO_Running,/usr/local/mysql/bin/mysql -e "show slave status\G"|grep Slave_IO_Running|grep -c "Yes"

UserParameter=mysql.Slave_SQL_Running,/usr/local/mysql/bin/mysql -e "show slave status\G"|grep Slave_SQL_Running|grep -c "Yes"

UserParameter=mysql.Seconds_Behind_Master,/usr/local/mysql/bin/mysql -e "show slave status\G"|grep Seconds_Behind_Master |awk '{print $2}'

UserParameter=mysql.innodb_lock,/usr/local/mysql/bin/mysql -e "SELECT count(*) FROM information_schema.INNODB_LOCK_WAITS w INNER JOIN information_schema.INNODB_TRX b ON b.trx_id= w.blocking_trx_id INNER JOIN information_schema.INNODB_TRX r ON r.trx_id= w.requesting_trx_id "|grep -v "count"

手工添加监控项和触发器。

监控项的键值就是 userparameter_mysql.conf 文件中等号右边第一个值，比如 mysql.processlist_count

添加触发器时，添加的表达式就是来自上述添加的监控项。

注意N值来源，先运行一下监控项的返回值，比如 mysql -e "select count(*) from information_schema.processlist where command !='Sleep' " |grep -v "count"