[dev.icinga.com #2056] Notification view is painfully slow

[icinga-migration]

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

Created by tgelf on 2011-11-09 10:49:51 +00:00

Assignee: jmosshammer
Status: Closed (closed on 2012-10-09 10:59:40 +00:00)
Target Version: (none)
Last Update: 2012-10-09 10:59:40 +00:00 (in Redmine)

Icinga Version: 1.5.2
Icinga Web Version: 1.5.2
IDO Version: 1.5.2
OS Version: Any
DB Type: MySQL
DB Version: 5.1
Browser Version: any

---

New indexes in GIT make it better, but the COUNT takes still ways too long once your notification table has grown a little bit.

Changesets

2012-03-02 15:45:15 +00:00 by jmosshammer 4e43388

* Wrote notification grid with new DQL templates (refs #2056)

2012-04-17 08:25:38 +00:00 by jmosshammer f2a541ec65dd8eb7b983ee266c7fcbcbd0f38611

* Wrote notification grid with new DQL templates (refs #2056)

2012-04-17 08:40:22 +00:00 by jmosshammer b36bde4

* Wrote notification grid with new DQL templates (refs #2056)

[icinga-migration]

Updated by jerico on 2011-11-15 14:40:36 +00:00

If I click on the Notifications cronk it never ends. Seems query takes to long and web site times out. So it seems the same issue like tgelf.

Command: Query
Time: 438
Status: Copying to tmp table
SQL Query: SELECT COUNT( * ) AS num_results
FROM (
SELECT i.notification_id
FROM icinga_notifications i
INNER JOIN

Would be grate if the query is limited by default. For example last 24 hours or configurable when you click on the cronk notifications.

[icinga-migration]

Updated by Frankstar on 2011-11-23 08:52:59 +00:00

Wich version we are talking about ?

latest git ?

[icinga-migration]

Updated by tgelf on 2011-11-23 10:13:26 +00:00

I tried 1.5.2 and git the day I created the ticket. For farther details related to this issue please see #1969.

[icinga-migration]

Updated by jmosshammer on 2012-03-01 17:04:26 +00:00

• Assigned to set to jmosshammer

[icinga-migration]

Updated by mhein on 2012-04-18 09:34:44 +00:00

• Status changed from New to Feedback

Hi.

Can you test this with the current git master, jm has changed the query handling and it should be very fast ;-)

[icinga-migration]

Updated by mfriedrich on 2012-09-24 12:19:52 +00:00

• Icinga Version set to 1
• Icinga Web Version set to 1
• IDO Version set to 1
• OS Version set to Any
• DB Type set to MySQL
• DB Version set to 5
• Browser Version set to any

[icinga-migration]

Updated by mfriedrich on 2012-09-24 12:20:05 +00:00

is this still the case, or can we close the issue?

[icinga-migration]

Updated by jmosshammer on 2012-10-09 10:59:40 +00:00

• Status changed from Feedback to Closed