Skip to content
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.

[dev.icinga.com #4985] bad update performance with large commenthistory table #1381

Closed
icinga-migration opened this issue Oct 31, 2013 · 2 comments
Milestone

Comments

@icinga-migration
Copy link

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

Created by mfriedrich on 2013-10-31 12:58:43 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2014-01-03 21:10:53 +00:00)
Target Version: 1.11
Last Update: 2014-12-08 14:38:17 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

due to the changes from #4544 the unique constraint and therefore index was changed and the delete_comments() retention.dat read triggering commenthistory updates (deletion_time) were using full table scans due to the missing index.

thanks to tom for debugging and testing.

CREATE INDEX commenthistory_delete_idx ON icinga_commenthistory (instance_id, comment_time, internal_comment_id);

Changesets

2014-01-03 20:10:39 +00:00 by (unknown) 48213c7

idoutils: fix bad update performance with large commenthistory table

Refs #4985

2014-01-03 20:10:59 +00:00 by (unknown) 185e1be

Merge branch 'fix/commenthistory-idx-4985' into next

Fixes #4985

Relations:

@icinga-migration
Copy link
Author

Updated by Anonymous on 2014-01-03 21:10:53 +00:00

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

Applied in changeset icinga-core:185e1bea184d6bcf7023dea99892df6f76c9a7b3.

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2014-12-08 14:38:17 +00:00

  • Project changed from 18 to Core, Classic UI, IDOUtils
  • Category changed from 57 to IDOUtils
  • OS Version set to any

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant