[dev.icinga.com #10070] IDO: there is no usable object index on icinga_{scheduleddowntime,comments}

[icinga-migration]

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

Created by tgelf on 2015-09-01 12:44:40 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2016-06-20 14:30:04 +00:00)
Target Version: 2.5.0
Last Update: 2016-11-11 08:46:54 +00:00 (in Redmine)

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

---

This makes queries joining downtime information to objects unnecessarily expensive.

Changesets

2016-06-20 14:23:57 +00:00 by mfriedrich a86e381

DB IDO: Add missing object_id index for icinga_{scheduleddowntime,comments} tables

fixes #10070
refs #11947

2016-06-20 15:15:09 +00:00 by mfriedrich f10289a

DB IDO: Add missing object_id index for icinga_{scheduleddowntime,comments} tables

fixes #10070
refs #11947

---

Relations:

• relates #11947
• relates #10070

[icinga-migration]

Updated by mfriedrich on 2015-09-01 14:21:15 +00:00

• Parent Id set to 10073

[icinga-migration]

Updated by mfriedrich on 2015-09-04 09:21:58 +00:00

• Status changed from New to Assigned

[icinga-migration]

Updated by mfriedrich on 2016-01-23 11:47:41 +00:00

• Status changed from Assigned to New
• Assigned to deleted tgelf

[icinga-migration]

Updated by tobiasvdk on 2016-06-20 13:54:56 +00:00

• Relates set to 11947

[icinga-migration]

Updated by mfriedrich on 2016-06-20 14:11:18 +00:00

• Subject changed from IDO: there is no usable object index on icinga_scheduleddowntime to IDO: there is no usable object index on icinga{scheduleddowntime,comments}_
• Target Version set to 2.5.0

[icinga-migration]

Updated by mfriedrich on 2016-06-20 14:19:23 +00:00

• Status changed from New to Assigned
• Assigned to set to mfriedrich

[icinga-migration]

Updated by mfriedrich on 2016-06-20 14:20:14 +00:00

• Relates set to 11967

[icinga-migration]

Updated by mfriedrich on 2016-06-20 14:30:04 +00:00

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

Applied in changeset a86e381.

[icinga-migration]

Updated by mfriedrich on 2016-11-11 08:46:54 +00:00

• Parent Id deleted 10073