Bug 1202661

Summary: Aggregation of disks usage is running slow
Product: Red Hat Enterprise Virtualization Manager Reporter: Shirly Radco <sradco>
Component: ovirt-engine-dwhAssignee: Shirly Radco <sradco>
Status: CLOSED ERRATA QA Contact: Petr Matyáš <pmatyas>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.5.0CC: gklein, lsurette, rbalakri, Rhev-m-bugs, yeylon, ykaul, ylavi
Target Milestone: ovirt-3.6.0-rcKeywords: ZStream
Target Release: 3.6.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1210988 (view as bug list) Environment:
Last Closed: 2016-03-09 21:23:10 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1210988    

Description Shirly Radco 2015-03-17 07:25:40 UTC 
Description of problem:
It was reported that the aggregation of vm_disks_usage_samples_history to hourly
was running slow.  

Version-Release number of selected component (if applicable):
3.5

How reproducible:


Steps to Reproduce:
1. Install and setup engine and dwh 3.5 environment.
2. Replace the ovirt_engine_history database with the one that sradco will supply to this bug.
3. Check performance of hourly aggregation

Actual results:
Very high cpu usage when performing hourly aggregations.

Expected results:
Should normal cpu usage and not have high impact on cpu usage. 

Additional info:
Should test that aggregation is same as before.

Perform test before and after the upgrade on the same data.
Comment 3 errata-xmlrpc 2016-03-09 21:23:10 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/RHEA-2016-0404.html