Bug 536238 (RHQ-60)

Summary: determine what oracle indexes we want to reindex by SystemManagerBean
Product: [Other] RHQ Project Reporter: John Mazzitelli <mazz>
Component: DatabaseAssignee: Charles Crouch <ccrouch>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: unspecifiedCC: asantos, hbrock, jshaughn
Target Milestone: ---Keywords: Task
Target Release: ---   
Hardware: All   
OS: All   
URL: http://jira.rhq-project.org/browse/RHQ-60
Whiteboard:
Fixed In Version: 1.4 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-05-14 14:19:35 UTC 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 John Mazzitelli 2008-03-12 15:11:00 UTC
We need to determine what indexes we want SystemManagerBean to periodically reindex on Oracle.

It currently reindexes these:

    private final String[] ORA_INDEXES = { "RHQ_MEAS_DATA_1H_ID_TIME_PK", "RHQ_MEAS_DATA_6H_ID_TIME_PK",
        "RHQ_MEAS_DATA_1D_ID_TIME_PK", "RHQ_MEAS_BASELINE_CTIME_IDX", "RHQ_MEAS_DATA_TRAIT_ID_TIME_PK",
        "RHQ_MEASUREMENT_OOB_IDX" };


Comment 1 Charles Crouch 2008-04-02 17:40:06 UTC
With mazz to investigate if any more need to be added.

Comment 2 Joseph Marques 2008-07-02 10:06:14 UTC
we need to do more performance testing to understand what, if anything else, has an access/insertion policy that necessitates adding them to the re-index list.  but this won't happen until after 1.1.0

Comment 3 John Mazzitelli 2008-10-10 20:55:21 UTC
this has been here for a while, has been pushed way out - so clearly, it isn't critical :) moving to "major"

Comment 4 John Mazzitelli 2008-11-07 20:13:04 UTC
unassigning - leave this for future work to be done

Comment 5 John Mazzitelli 2008-11-20 15:32:08 UTC
Update this page when we decide what to do:

http://support.rhq-project.org/display/RHQ/Design-AllDBTables

Comment 6 John Mazzitelli 2009-01-30 22:30:07 UTC
there may be nothing we have to do for this - but we should do a quick check to see if we need to reindex others

Comment 7 Joseph Marques 2009-03-20 11:11:41 UTC
if we end up getting our performance testing hardware back before 1.2 release, there are other bigger fish to fry than this - namely the performance of the cluster nav tree.  plus, we've been operating with the original index list for nearly a year now, so if things were really bad one would hope those issues would have shown up by now.

Comment 8 Red Hat Bugzilla 2009-11-10 21:13:11 UTC
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-60


Comment 10 Jay Shaughnessy 2014-05-14 14:19:35 UTC
relying on perf test team to make these recommendations