[#HHQ-1795] Missing index on EAM_METRIC_AUX_LOGS.metric_id

Hyperic HQ

Missing index on EAM_METRIC_AUX_LOGS.metric_id

Created: 10/Mar/08 04:31 PM Updated: 17/Mar/08 03:26 PM

Component/s:

Measurement

Affects Version/s:

3.2.1

Fix Version/s:

4.0.0, 3.2.2

Issue Links:

Depends

This issue Is related to:

HHQ-1788 Upgrade takes around 26 minutes 25 seconds to complete

Verify By:	Kashyap Parikh
Last comment:	29 weeks, 4 days ago
Resolution Date:	10/Mar/08 05:03 PM

Description

« Hide

This was originally discovered via bug HHQ-1788.

There is a missing index on EAM_METRIC_AUX_LOGS.metric_id which has a foreign key constraint into EAM_MEASUREMENT. This means on deletes from EAM_MEASUREMENT the database needs to do a full table scan on EAM_METRIC_AUX_LOGS to check constraints. This results in slow deletes of Measurement objects.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Ryan Morgan - 10/Mar/08 05:03 PM

Fixed in 4.0.0 build #652 and 3.2.2 build #636

[ Permlink | « Hide ]

Kashyap Parikh - 17/Mar/08 03:26 PM

Verified new index exists with 3.2.2 #640 on postgres and mysql DBs