#2513 [HHQ-2278] Remove all MySQL auto-created indexes for foreign

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-2278
MySQL currently generates an index where ever a foreign key constraint exists, even if an index currently exists on that row.

I have seen a decent performance impact even on smaller running HQ instances (e.g. my desktop) where queries/updates will timeout with the indexes and no impact without the additional indexes.

Unfortunately in innodb all foreign keys need an index or joins simply will not work, and in HQ without this auto create mechanism we do not have all foreign keys mapped to an index.

Therefore, two tasks here ->

1) remove all auto created mysql indexes (indexes ending with _YY) in db-upgrade.xml, which resides in MySQL Hibernate Dialect.


2) verify that all HQ foreign keys are mapped to indexes and add accordingly