Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
icinga-migration opened this issue Sep 1, 2015 · 9 comments

Comments

Projects
None yet
1 participant
@icinga-migration
Copy link
Member

commented Sep 1, 2015

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:

@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Sep 1, 2015

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

  • Parent Id set to 10073
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Sep 4, 2015

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

  • Status changed from New to Assigned
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jan 23, 2016

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

  • Status changed from Assigned to New
  • Assigned to deleted tgelf
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jun 20, 2016

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

  • Relates set to 11947
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jun 20, 2016

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

This comment has been minimized.

Copy link
Member Author

commented Jun 20, 2016

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

This comment has been minimized.

Copy link
Member Author

commented Jun 20, 2016

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

  • Relates set to 11967
@icinga-migration

This comment has been minimized.

Copy link
Member Author

commented Jun 20, 2016

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

This comment has been minimized.

Copy link
Member Author

commented Nov 11, 2016

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

  • Parent Id deleted 10073
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.