Red Hat Bugzilla – Bug 534570
Investigate use of additional indices on tables we purge from
Last modified: 2015-02-01 18:24:58 EST
We should do some investigation into whether our purge process could be improved by having some additional indexes, e.g on the TIME_STAMP columns, on tables we could end up deleting a lot of rows from, e.g. events, 1h, 6h, 1d tables. We obviously need to also make sure that insert performance is not significantly impacted by having to update any new index.
i've also seen some table contention issues in the alert subsystem. if there is load on the system, and you try to update an alert template, it will not always completely successfully. ugly stack in the ui.
duplicate of RHQ-2376, which is already resolved
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1354
This bug is related to RHQ-1336