Bug 1328709 - [z-stream clone - 3.6.6] RHEV DWH database growing excessively
Summary: [z-stream clone - 3.6.6] RHEV DWH database growing excessively
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh
Version: 3.5.7
Hardware: All
OS: Linux
high
high
Target Milestone: ovirt-3.6.6
: ---
Assignee: Shirly Radco
QA Contact: mlehrer
URL:
Whiteboard:
Depends On: 1321517
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-04-20 06:35 UTC by rhev-integ
Modified: 2019-12-08 22:46 UTC (History)
13 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Previously, in large environments the delete job took longer than it should have (around 5 hours). This caused a load on the sampling process, data was not deleted, and a backlog was created for large sampling tables such as vm_interface_samples_history and vm_disk_samples_history. This release adds a mechanism that will allow the samples deletion process to become more aggressive according to the following parameters: the number of times the deletion loop runs; the Initial and Increment values; and the number of iterations between increments. In addition, the DWH_LIMIT_ROWS parameter enables updating the hourly and daily deletion process with the amount of rows to be deleted in each iteration. The deletion process is now more dynamic, and can be customized according to the environment, so the delete process will not take longer than 5 hours.
Clone Of: 1321517
Environment:
Last Closed: 2016-05-25 12:02:39 UTC
oVirt Team: Metrics
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2016:1114 0 normal SHIPPED_LIVE rhevm-dwh 3.6.6 bug fix update 2016-05-25 16:00:32 UTC
oVirt gerrit 55690 0 ovirt-engine-dwh-3.6 MERGED history: changed the limit in DeleteTimekeeping job 2016-04-20 06:36:04 UTC
oVirt gerrit 55716 0 ovirt-engine-dwh-3.5 MERGED history: changed the limit in DeleteTimekeeping job 2016-04-20 06:36:04 UTC
oVirt gerrit 56066 0 master MERGED history: changed the limit in DeleteTimekeeping job 2016-04-20 06:36:04 UTC

Comment 4 errata-xmlrpc 2016-05-25 12:02:39 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2016-1114.html


Note You need to log in before you can comment on or make changes to this bug.