Skip to content
This repository has been archived by the owner. It is now read-only.

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

Closed
icinga-migration opened this issue Nov 9, 2011 · 8 comments
Labels
bug

Comments

@icinga-migration
Copy link
Member

@icinga-migration icinga-migration commented Nov 9, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 15, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 23, 2011

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

Wich version we are talking about ?

latest git ?

@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 23, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Mar 1, 2012

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

  • Assigned to set to jmosshammer
@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Apr 18, 2012

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Sep 24, 2012

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Sep 24, 2012

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Oct 9, 2012

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

  • Status changed from Feedback to Closed
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
1 participant
You can’t perform that action at this time.