[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opennms-buglist
Subject:    [Buglist] [Bug 3446] New: Enabling thresholding causes excessive SQL traffic
From:       bugzilla () opennms ! org (bugzilla at opennms ! org)
Date:       2009-11-20 6:40:46
Message-ID: bug-3446-627 () http ! bugzilla ! opennms ! org/
[Download RAW message or body]

http://bugzilla.opennms.org/show_bug.cgi?id=3446

           Summary: Enabling thresholding causes excessive SQL traffic
           Product: OpenNMS
           Version: 1.6.7
          Platform: All
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P1
         Component: Thresholding
        AssignedTo: buglist at opennms.org
        ReportedBy: frank at dough.net


We have an OpenNMS 1.6.7 server monitoring 272 nodes with 3901 interfaces,
although each node has only 1 or 2 interfaces actually monitored.  We
noticed the 100Mb connection between the poller and database server being
pegged so we replaced with a gigabit switch.  Now the interface is spiking
up to 300-400Mbps.  This is the traffic coming from the database server to
OpenNMS.  I did a tcpdump and virtually all of the traffic is repeated
calls of this query:

SELECT * FROM snmpinterface WHERE nodeid = '325'

The actual nodeid varies, but they are repeated a lot.  I saw one node
query repeated over 100 times in a capture that was about 5 seconds long.

David Hustace suggested disabling thresholding and that made the problem go
away.


-- 
Configure bugmail: http://bugzilla.opennms.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

[prev in list] [next in list] [prev in thread] [next in thread]