[dev.icinga.com #12107] Add missing index on state history for DB IDO cleanup

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/12107

Created by mfriedrich on 2016-07-06 09:56:10 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2016-07-06 10:20:04 +00:00)
Target Version: 2.5.0
Last Update: 2016-07-06 10:20:04 +00:00 (in Redmine)

Icinga Version: 2.4.10
Backport?: Not yet backported
Include in Changelog: 1

---

CREATE INDEX idx_statehistory_cleanup on icinga_statehistory(instance_id, state_time);

The mysql query optimiser will decide upon the given comparison (state_time > $datetime) whether an index or a full table scan is required. Currently the DELETE operations from inside the IDO feature depends on a proper index.

http://stackoverflow.com/questions/18297509/mysql-index-on-timestamp-column-not-used-for-large-date-ranges

Changesets

2016-07-06 10:17:41 +00:00 by mfriedrich a0a5989

Add missing index on statehistory table for DB IDO cleanup

fixes #12107

[icinga-migration]

Updated by mfriedrich on 2016-07-06 10:06:03 +00:00

• Description updated

[icinga-migration]

Updated by mfriedrich on 2016-07-06 10:20:04 +00:00

• Status changed from Assigned to Resolved
• Done % changed from 0 to 100

Applied in changeset a0a5989.