######
模板Template DB MySQL自带的触发器:
名称: MySQL: Server has aborted connections (over {$MYSQL.ABORTED_CONN.MAX.WARN} for 5m)
表达式: {MariaDB_1:mysql.aborted_connects.rate.min(5m)}>{$MYSQL.ABORTED_CONN.MAX.WARN}
注释: {$MYSQL.ABORTED_CONN.MAX.WARN} 是宏,继承于模板Template DB MySQL,默认值为 3
######
模板Template DB MySQL自带的监控MariaDB服务状态的监控项:
名称: Availability: MySQL status
键值: mysql.ping["{$MYSQL.HOST}","{$MYSQL.PORT}"]
在Zabbix服务器测试,检测远程MariaDB服务有没有在运行中:(在运行时;MariaDB服务的默认端口为TCP 3306;无需在被监控主机的防火墙打开TCP 3306端口)
[root@centos8 ~]# /usr/local/zabbix/bin/zabbix_get -s 192.168.168.129 -k mysql.ping["localhost","3306"]
mysqld is alive
[root@centos8 ~]#
检测远程MariaDB服务有没有在运行中:(没有运行时)
[root@centos8 ~]# /usr/local/zabbix/bin/zabbix_get -s 192.168.168.129 -k mysql.ping["localhost","3306"]
d:\UPUPW_AP5.6\MariaDB\bin\mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061 "Unknown error")'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'
[root@centos8 ~]#
注释:
键值的格式要改变一下,不要使用变量;
这相当于在被监控主机上进行本地监控,所以应该使用"localhost"
模板Template DB MySQL自带的监控MariaDB服务状态的触发器:
名称: MySQL: Service is down
表达式: {MariaDB_1:mysql.ping["{$MYSQL.HOST}","{$MYSQL.PORT}"].last()}=0
注释:这告警10分钟后自动消失。
######
模板Template DB MySQL有自动检查MariaDB各个库的大小的监控项:
监控项名称: Info: Size of database mysql
键值: mysql.dbsize["{$MYSQL.HOST}","{$MYSQL.PORT}","mysql"]