Bug 1135603

Summary:	Drop metrics_cache table
Product:	[Other] RHQ Project	Reporter:	John Sanda <jsanda>
Component:	Core Server, Storage Node	Assignee:	Nobody <nobody>
Status:	ON_QA ---	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	4.12	CC:	hrupp
Target Milestone:	---
Target Release:	RHQ 4.13
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1135604 (view as bug list)		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1135604

Description John Sanda 2014-08-29 18:47:36 UTC

Description of problem:
I introduced the metrics_cache table in RHQ 4.12 as a way to reduce queries required during metrics data aggregation. This was intended as a performance optimization. It is described at https://docs.jboss.org/author/display/RHQ/Aggregation+Schema+Changes. I have learned in part from community feedback (i.e., Elias Ross), that the gains are often minimal because there are not tight groupings of schedule ids. 

More importantly the new table causes higher heap usage which can result in lots of alert notifications especially for default installations. This could be problematic for a lot of users who run only a single, co-located storage node along side the server. We are better of dropping the table. I think rhq-metrics would be a more appropriate place to explore changes like this.

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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 John Sanda 2014-09-12 01:38:20 UTC

The work for this has been done under bug 1135629. Moving to ON_QA.