modules/core/dbutils/src/main/scripts/dbupgrade/db-upgrade.xml | 8 ++++++++
1 file changed, 8 insertions(+)
New commits:
commit 2ba9e1c4cfcb7046bfce34996d4955b0091c08a6
Author: Lukas Krejci <lkrejci(a)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 -->
Show replies by date