modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml | 8 ++++++++ 1 file changed, 8 insertions(+)
New commits: commit 2ba9e1c4cfcb7046bfce34996d4955b0091c08a6 Author: Lukas Krejci lkrejci@redhat.com Date: Thu Dec 16 12:23:48 2010 +0100
BZ 656469 - adding a temporary performance measure on the RHQ_MEASUREMENT_DATA_NUM_1D. Having an index on TIME_STAMP column helps the performance of the hourly jobs but a more involved solution is needed to fix this bottleneck.
This fix is part of RHQ 3.0.1 as well and therefore was added as schema spec 2.92.4 even though master is currently on schema spec 2.101. This is to support seamless upgrade of the releases, but of course intermittently this is schema spec is not going to get applied until a full dbsetup is executed.
diff --git a/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml b/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml index 1483436..d9f63c0 100644 --- a/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml +++ b/modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml @@ -3130,6 +3130,14 @@ <schema-alterColumn table="RHQ_PARTITION_EVENT" column="SUBJECT_NAME" columnType="VARCHAR2" precision="100" /> </schemaSpec>
+ <schemaSpec version="2.92.4"> + <schema-directSQL> + <statement desc="Add index on measurement data 1d table timestamp"> + CREATE INDEX RHQ_MEAS_DATA_1D_TIME_IDX ON RHQ_MEASUREMENT_DATA_NUM_1D (time_stamp) + </statement> + </schema-directSQL> + </schemaSpec> + <schemaSpec version="2.93"> <!-- the customizable dashboard storage system -->
rhq-commits@lists.fedorahosted.org