Bug 535430 (RHQ-2126)

Summary: change dynagroup backend to use availability precompute data
Product: [Other] RHQ Project Reporter: Joseph Marques <jmarques>
Component: Core ServerAssignee: Joseph Marques <jmarques>
Status: CLOSED NEXTRELEASE QA Contact: Corey Welton <cwelton>
Severity: medium Docs Contact:
Priority: medium    
Version: unspecifiedKeywords: Improvement
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
URL: http://jira.rhq-project.org/browse/RHQ-2126
Whiteboard:
Fixed In Version: 1.3 Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Joseph Marques 2009-06-02 19:01:00 UTC
from http://jira.rhq-project.org/browse/RHQ-965 -- ExpressionEvaluator uses a join to the rhq_availability table where endtime is null to find the latest availability for each resource.

a few months after that was implemented, we added precomputation of the current availability for a resource.  we should be using that for dynagrouping purposes, as it requires only a fraction of the cost to calculate.

Comment 1 Joseph Marques 2009-06-02 19:10:25 UTC
rev4019 - swtich dyangorup implementation to use currentAvailability precompute column instad of hitting the rhq_availability where endtime is null condition; 

Comment 2 Charles Crouch 2009-06-02 19:33:53 UTC
Need to test this on a large inventory (100k resources) with a dyna group such as "show me all down resources" and "show me all up resources" recalculating every minute.

Comment 3 Joseph Marques 2009-06-03 01:26:29 UTC
branches/RHQ_1_2_0_GA_CP: rev4024 - swtich dyangorup implementation to use currentAvailability precompute column instad of hitting the rhq_availability where endtime is null condition;

Comment 4 Corey Welton 2009-08-17 20:37:37 UTC
[16:32] <joseph> you can test it by just creating an availability based expression
[16:32] <joseph> resource.availability = UP
[16:32] <joseph> resource.availability = DOWN
[16:32] <joseph> groupby resource.availability
[16:33] <joseph> if those work correctly, then it's verified

QA Verified.

Comment 5 Red Hat Bugzilla 2009-11-10 20:58:21 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-2126