[dev.icinga.com #2550] performance issues with enable_sla=1

[icinga-migration]

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

Created by mfriedrich on 2012-04-25 10:39:31 +00:00

Assignee: (none)
Status: Closed (closed on 2012-11-21 12:40:20 +00:00)
Target Version: (none)
Last Update: 2014-12-08 14:37:41 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

---

happen too often lately.

http://www.monitoring-portal.org/wbb/index.php?page=Thread&threadID=25711
http://www.monitoring-portal.org/wbb/index.php?page=Thread&threadID=25397

[icinga-migration]

Updated by mfriedrich on 2012-05-05 11:41:42 +00:00

• Status changed from New to Assigned
• Priority changed from High to Normal

[icinga-migration]

Updated by mopp on 2012-08-08 13:24:43 +00:00

I ran into the same problem described here [[http://www.monitoring-portal.org/wbb/index.php?page=Thread&threadID=25711\]\]
The result is ido2db uses 100% CPU
Setting enable_sla=0 in ido2db.cfg fixed the problem.
The problem seems to start when the table slahistory gets too big.

In the ido2db log files you see queries like this which took very long time. The result was the Icinga deamon was not able to communicate with ido2db, because it is busy.

SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '426' AND ((start_time > FROM_UNIXTIME(1343826917) AND start_time < FROM_UNIXTIME(1344845700)) OR (end_time > FROM_UNIXTIME(1343826917) AND end_time < FROM_UNIXTIME(1344845700)) OR (start_time < FROM_UNIXTIME(1343826917) AND end_time > FROM_UNIXTIME(1344845700)) OR (end_time IS NULL))

[icinga-migration]

Updated by mfriedrich on 2012-08-31 16:48:30 +00:00

• Icinga Version set to 1
• (unknown custom field) set to 1
• OS Version set to Debian
• (unknown custom field) set to MySQL
• (unknown custom field) set to 5

[icinga-migration]

Updated by mfriedrich on 2012-11-06 14:04:55 +00:00

• Assigned to deleted gbeutner

[icinga-migration]

Updated by mfriedrich on 2012-11-06 14:05:32 +00:00

• Status changed from Assigned to Feedback

[icinga-migration]

Updated by mfriedrich on 2012-11-21 12:40:20 +00:00

• Status changed from Feedback to Closed

[icinga-migration]

Updated by mfriedrich on 2012-11-21 12:43:13 +00:00

enable_sla will be deprecated in 1.9 due to the performance problems, as well as their missing use cases.

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:37:41 +00:00

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