Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-10506

Node page very slow to load for nodes with more than 1000 events

    XMLWordPrintable

Details

    • Horizon - January 9th 2019, Horizon - January 23rd 2019, Horizon - January 30th 2019, Horizon - January 30th-2 2019

    Description

      The following "long running" query was found by a customer that is reporting that a few nodes have a very long load time on the node page.  Several customers are reporting this problem.

               SELECT events.*,
                       node.nodelabel,
                       service.servicename,
                       monitoringsystems.id AS systemId,
                       monitoringsystems.label AS systemLabel,
                       monitoringsystems.location AS location
                  FROM node
      RIGHT OUTER JOIN events
                    ON (events.nodeid = node.nodeid)
       LEFT OUTER JOIN monitoringsystems
                    ON (events.systemid = monitoringsystems.id)
       LEFT OUTER JOIN service
                    ON (service.serviceid = events.serviceid)
                 WHERE EVENTACKUSER IS NULL
                   AND EVENTS.NODEID = <node id>
                   AND EVENTDISPLAY='Y'
              ORDER BY EVENTID
                  DESC
                 LIMIT 5
                OFFSET 0;
      

      Attachments

        Activity

          People

            j-white Jesse White
            david David Hustace
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.