【问题解决】Zabbix告警housekeeper processes more than 75% busy

最新推荐文章于 2025-04-10 09:48:41 发布

草莓甜甜圈

最新推荐文章于 2025-04-10 09:48:41 发布

阅读量6k

点赞数 1

分类专栏：解决问题 monitor 文章标签：运维

本文链接：https://blog.csdn.net/qq_39626154/article/details/125679840

版权

monitor 同时被 2 个专栏收录

20 篇文章

订阅专栏

解决问题

16 篇文章

订阅专栏

本文介绍了Zabbix中housekeeper机制导致数据库查询变慢的问题，并提出了解决方案。通过调整HousekeepingFrequency参数为6小时执行一次，以及MaxHousekeeperDelete参数为10000条，可以有效改善数据库性能，防止查询延迟。建议根据实际服务器性能适当调整这两个参数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题原因

为了防止数据库持续增大，zabbix有个自动删除历史数据的机制，就是housekeeper，而mysql数据库删除数据较多的情况下，性能会降低，zabbix查询变慢，就会报这个错误。

解决方案

调整HousekeepingFrequency与MaxHousekeeperDelete参数，我这里设置为6小时执行一次，每次执行最大删除条目为10000。这个根据实际机器性能可以自行调整。

### Option: HousekeepingFrequency
#       How often Zabbix will perform housekeeping procedure (in hours).
#       Housekeeping is removing outdated information from the database.
#       To prevent Housekeeper from being overloaded, no more than 4 times HousekeepingFrequency
#       hours of outdated information are deleted in one housekeeping cycle, for each item.
#       To lower load on server startup housekeeping is postponed for 30 minutes after server start.
#       With HousekeepingFrequency=0 the housekeeper can be only executed using the runtime control option.
#       In this case the period of outdated information deleted in one housekeeping cycle is 4 times the
#       period since the last housekeeping cycle, but not less than 4 hours and not greater than 4 days.
#
# Mandatory: no
# Range: 0-24
# Default:
HousekeepingFrequency=6

### Option: MaxHousekeeperDelete
#       The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
#       [housekeeperid], [tablename], [field], [value].
#       No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
#       will be deleted per one task in one housekeeping cycle.
#       If set to 0 then no limit is used at all. In this case you must know what you are doing!
#
# Mandatory: no
# Range: 0-1000000
# Default:
MaxHousekeeperDelete=10000