Zabbix housekeeper processes more than 75% busy
收到Zabbix housekeeper processes more than 75% busy 报警,
问题原因
为了防止数据库持续增大,zabbix有个自动删除历史数据的机制,就是housekeeper,而mysql数据库删数据的时候,性能会降低,就会报这个错误,
解决方法如下:
调整HousekeepingFrequency参数,设置为3小时执行一次
vim /usr/local/zabbix/etc/zabbix_server.conf
HousekeepingFrequency=3 #间隔时间
MaxHousekeeperDelete=3000 #最大删除量
重新启动zabbix_server生效:
/etc/init.d/zabbix_server restart
查看log发现删除时已经带上了最大3000行
tail -f /tmp/zabbix_server.log
10622:20181109:162644.037 resuming Zabbix agent checks on host "ETS-DB": connection restored
10005:20181109:162646.629 slow query: 6.579011 sec, "delete from history_uint where itemid=40531 limit 3000"
10005:20181109:162659.356 slow query: 4.364114 sec, "delete from history_uint where itemid=40399 limit 3000"
10024:20181109:162701.359 item "dbnode1:uptime" became not supported: Unsupported item key.
10033:20181109:162713.585 item "OA-DB:uptime" became not supported: Unsupported item key.
10676:20181109:162718.903 cannot send list of active checks to "192.168.255.148": host [PingAn-Bank] not found
10005:20181109:162722.824 slow query: 23.467607 sec, "delete from history_uint where itemid=40510 limit 3000"
10680:20181109:162724.601 cannot send list of active checks to "192.168.255.132": host [WINN5F1QHDELEP] not found
10038:20181109:162735.390 item "dbnode1_zs:uptime" became supported
10005:20181109:162745.124 slow query: 22.299782 sec, "delete from history_uint where itemid=40515 limit 3000"
10025:20181109:162757.104 item "dbnode1_zs:uptime" became not supported: Unsupported item key.
10005:20181109:162806.766 slow query: 21.642425 sec, "delete from history_uint where itemid=40505 limit 3000"
10005:20181109:162812.225 slow query: 5.458863 sec, "delete from history_uint where itemid=40511 limit 3000"
10016:20181109:162817.036 item "dbnode1_zs:uptime" became supported
10005:20181109:162818.444 slow query: 6.217885 sec, "delete from history_uint where itemid=40516 limit 3000"
10005:20181109:162824.287 slow query: 5.843189 sec, "delete from history_uint where itemid=40506 limit 3000"
Tag标签:「zabbix housekeeper」更新时间:「2021-11-04 22:46:01」阅读次数:「847」