[dev.icinga.com #2051] Housekeeping for notification tables

[icinga-migration]

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

Created by tgelf on 2011-11-08 14:38:42 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2011-11-15 17:00:49 +00:00)
Target Version: 1.6
Last Update: 2014-12-08 14:46:26 +00:00 (in Redmine)

---

Afaik there is currently no housekeeping mechanism for notification tables. Therefore, the following tables are silently growing:

• icinga_notifications
• icinga_contactnotifications
• icinga_contactnotificationmethods

As Icinga-Web is running pretty heavvy queries against those tables cleaning them up from time to time would really help.

Changesets

2011-11-10 14:47:58 +00:00 by mfriedrich edb02ba

* idoutils: add max_notifications_age, max_contactnotifications_age, max_contactnotificationmethods_age as housekeeping for notification tables #2051

refs #2051

---

Relations:

• relates #2051

[icinga-migration]

Updated by mfriedrich on 2011-11-09 13:34:26 +00:00

• Category set to 82
• Status changed from New to Assigned
• Assigned to set to mfriedrich
• Priority changed from Normal to Low

makes sense, and is rather easy to be implemented.

[icinga-migration]

Updated by mfriedrich on 2011-11-10 14:48:51 +00:00

• Target Version set to 1.6

pushed to dev/ido - can you please test that?

[icinga-migration]

Updated by mfriedrich on 2011-11-15 17:00:49 +00:00

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

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:46:26 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 82 to IDOUtils