-
Problem report
-
Resolution: Fixed
-
Major
-
3.0.24
-
None
-
Sprint 47, Dec 2018, Sprint 56 (Sep 2019), Sprint 55 (Aug 2019), Sprint 49 (Feb 2019), Sprint 50 (Mar 2019), Sprint 51 (Apr 2019), Sprint 52 (May 2019), Sprint 53 (Jun 2019), Sprint 54 (Jul 2019), Sprint 57 (Oct 2019)
-
0.5
Hi,
Either there is a bug or something I don't understand, apologies if it's the latter!
We're planning an upgrade from v3.4.14 to v4 and in anticipation of a large and slow data upgrade (85GB DB) we've reduced the history period to 1d in Administration > Housekeeping. Typical values are 1w to 2w.
As data sizes didn't reduce significantly, we're looked in the DB and found very old data which hasn't been removed by the housekeeper (which we've confirmed is running in the log and also run manually).
Current settings:
Events and alerts
Enable internal housekeeping YES
Trigger data storage period 90d
Internal data storage period 30d
Network discovery data storage period 7d
Auto-registration data storage period 7d
Services
Enable internal housekeeping YES
Data storage period 7d
Audit
Enable internal housekeeping YES
Data storage period 7d
User sessions
Enable internal housekeeping YES
Data storage period 7d
History
Enable internal housekeeping YES
Override item history period YES
Data storage period 1d
Trends
Enable internal housekeeping YES
Override item trend period YES
Data storage period 365d
Data which we see in the DB is as follows:
- events: 2017-09-27
- history: 2018-09-14
- history_text: 2016-07-11
- history_uint: 2014-10-14
- trends: 2014-10-08
- trends_uint: 2014-10-08
- Data sizes and row counts:
Table | Size in MB | Row count |
trends_uint | 21,220 | 307,061,092 |
history_uint | 19,208 | 45,394,092 |
event_recovery | 13,271 | 62,080,921 |
EVENTS | 12,427 | 152,549,952 |
trends | 2,612 | 33,321,085 |
history | 1,802 | 3,772,682 |
history_text | 1,695 | 1,911,462 |
history_str | 567 | 3,605,497 |
Thanks!
- depends on
-
ZBXNEXT-5176 Take in consideration history storage period with 0 on housekeep override
- Closed
- is duplicated by
-
ZBX-17069 housekeeper deleted 0 hist/trends
- Closed