[ZBX-6542] Document the potential role of HousekeepingFrequency in connection with the range of history/trends cleanups Created: 2013 Apr 26  Updated: 2017 May 30  Resolved: 2014 Apr 15

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Documentation (D)
Affects Version/s: 2.0.6
Fix Version/s: 2.0.14rc1, 2.2.8rc1, 2.4.3rc1, 2.5.0

Type: Incident report Priority: Trivial
Reporter: Marc Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: housekeeper
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

If I understand delete_history() right it doesn't always delete everything older than the configured history of an item.
It's only done this way if the configured history subtracted from the current time is lower than the time of the oldest history entry added with four times HousekeepingFrequency.

Maybe this should be mentioned in the documentation - on condition that I'm not wrong



 Comments   
Comment by Oleksii Zagorskyi [ 2013 Apr 27 ]

Should be probably fixed together with ZBX-6541

Comment by Oleksii Zagorskyi [ 2013 Apr 27 ]

Also - not everything older than the configured history of an item !
There is one sanity check to save performance if you for example change history/trends from 720 days to 2 days.

It will be deleted not in one go, but in several/many small batches.

Comment by Martins Valkovskis [ 2014 Apr 04 ]

This detail added to documentation:

https://www.zabbix.com/documentation/2.0/manual/appendix/config/zabbix_server
https://www.zabbix.com/documentation/2.2/manual/appendix/config/zabbix_server

(see 'HousekeepingFrequency' parameter description)

Comment by Marc [ 2014 Apr 04 ]

I'm happy with that

Comment by richlv [ 2014 Apr 12 ]

(1) i was considering for some time whether we should add the same info to the config files to make them more useful & be more consistent.
i got to the conclusion that we should

sasha RESOLVED in:

  • svn://svn.zabbix.com/branches/2.0 r44359:44360
  • svn://svn.zabbix.com/branches/2.2 r44361
  • svn://svn.zabbix.com/trunk r44362

please review

martins-v Looking good to me.

<richlv>
a) sorry for nitpicking, but "4xHousekeepingFrequency" doesn't look very readable to me. "4 x HousekeepingFrequency" is a bit strange as well, so i'd suggest to make it "4 times HousekeepingFrequency"
b) while we're at this, there is a line saying "Housekeeping is removing unnecessary information from history, alert, and alarms tables.". we don't have 'alarms' table, and this is missing quite a bunch of tables. we should either list all the tables or just change it to something more generic like "...removing outdated information from the database."

martins-v Introduced to:

(and also the same docs for 2.0, 2,2 and 3.0 branches). Please review. Again, for consistency, this would have to be synced with config files.

sasha Very good! But Zabbix proxy doesn't apply "4 times HousekeepingFrequency" for "each item". It applied for all values in history tables.

.. and "when history periods are greatly reduced" should be replaced by "when configuration parameters ProxyLocalBuffer or ProxyOfflineBuffer are greatly reduced"

martins-v Thanks, fixed according to suggestions: https://www.zabbix.com/documentation/2.4/manual/appendix/config/zabbix_proxy

RESOLVED.

sasha Thank you. CLOSED

Comment by Alexander Vladishev [ 2014 Oct 27 ]

(2) For consistency, this would have to be synced with config files.

sasha RESOLVED directly in 2.0, 2.2, 2.4 and trunk branches in r50247.

(2a) asaveljevs In trunk configuration file for proxy, it says "In this case the period of outdated history...". For server, it says "In this case the period of outdated information...". It should be "information" in both cases.

sasha RESOLVED in r50566.

asaveljevs CLOSED

(2b) asaveljevs Also, let's change "Housekeeper" to "the housekeeper". REOPENED.

sasha RESOLVED in 1.8, 2.0, 2.2, 2.4 and 3.0 documentation pages. Also changed "Housekepper Frequency" to "HousekepperFrequency" in 3.0.

asaveljevs Additionally changed "Housekeeper" to "housekeeper" at https://www.zabbix.com/documentation/2.4/manual/appendix/config/zabbix_server - that seems to have been missed. RESOLVED.

sasha Many thanks! CLOSED

Generated at Fri Apr 26 21:16:06 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.