Bug 1135603 - Drop metrics_cache table
Summary: Drop metrics_cache table
Status: ON_QA
Alias: None
Product: RHQ Project
Classification: Other
Component: Core Server, Storage Node
Version: 4.12
Hardware: Unspecified
OS: Unspecified
unspecified vote
Target Milestone: ---
: RHQ 4.13
Assignee: RHQ Project Maintainer
QA Contact: Mike Foley
Depends On:
Blocks: 1135604
TreeView+ depends on / blocked
Reported: 2014-08-29 18:47 UTC by John Sanda
Modified: 2019-03-08 22:42 UTC (History)
1 user (show)

Clone Of:
: 1135604 (view as bug list)
Last Closed:

Attachments (Terms of Use)

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:

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.

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