Yes mysql is running local. As you can see with this screenshot of top mysql is only running 1.3% cpu. As of right now it will take two hours to pollor 22 devices.

top - 20:27:27 up 26 min,  1 user,  load average: 0.13, 0.04, 0.01
Tasks: 187 total,   1 running, 186 sleeping,   0 stopped,   0 zombie
Cpu(s):  2.7%us,  1.0%sy,  0.0%ni, 95.4%id,  0.8%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   3924572k total,   504916k used,  3419656k free,    21440k buffers
Swap:  4063224k total,        0k used,  4063224k free,   130340k cached
PID to kill:
  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 4252 root      20   0  163m  18m 6616 S  7.6  0.5   0:00.46 php
 1857 mysql     20   0 1591m  33m 6428 S  1.3  0.9   0:02.04 mysqld
 4797 root      20   0 21588 2668 1612 S  1.0  0.1   0:00.03 snmpbulkwalk
 4256 root      20   0 54660 1944 1568 S  0.7  0.0   0:00.02 rrdtool
 1924 root      20   0 15024 1388 1008 R  0.3  0.0   0:03.83 top
 2182 root      20   0  163m  17m 6644 S  0.3  0.5   0:01.15 php
 4795 root      20   0 21456 2400 1600 S  0.3  0.1   0:00.01 snmpget
    1 root      20   0 19228 1560 1268 S  0.0  0.0   0:01.55 init



On Sat, Jun 22, 2013 at 8:19 PM, Tom Laermans <tom.laermans@powersource.cx> wrote:
Mysql on the same machine? What does show processlist or mytop say?

Sent from my mobile, please excuse brevity and spelling errors.


----- Reply message -----
From: "Zach Underwood" <zunder1990@gmail.com>
To: "Observium Network Observation System" <observium@observium.org>
Subject: [Observium] Problem very LONG poll times
Date: Sat, Jun 22, 2013 22:21


Ok I pick one network switch and disable about 75% of the unused module on this switch and I got the poll down to 109 sec. This same 24 port switch was taking only 10sec to poll. In watch the debug poll on a few devices it looks like all of the modules are slow.


On Sat, Jun 22, 2013 at 3:22 PM, Adam Armstrong <adama@memetic.org> wrote:

Even less of an idea now.

What happens if you try to run one of the snmp queries it runs?

Have you noticed any particular module being slow?


On 2013-06-22 19:38, Zach Underwood wrote:
Here is top. This was taken during a poll
There is almost no network traffic. This vm is only uesd for observium.
[root@observium init.d]# top
top - 14:12:01 up  3:34,  4 users,  load average: 0.00, 0.01, 0.00
Tasks: 143 total,   1 running, 142 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.4%us,  0.1%sy,  0.0%ni, 99.5%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   3924572k total,   591700k used,  3332872k free,    42380k buffers
Swap:  4063224k total,        0k used,  4063224k free,   282400k cached
PID to kill:
  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
10878 root      20   0  116m 3044 1656 S  1.0  0.1   0:00.06
/usr/bin/snmpget -v1 -c           -Otv -M /opt/observium/mibs udp:p
10862 root      20   0 15024 1344 1012 R  0.5  0.0   0:00.06 top
    1 root      20   0 19356 1572 1268 S  0.0  0.0   0:01.65 /sbin/init
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.01 [kthreadd]
    3 root      RT   0     0    0    0 S  0.0  0.0   0:00.01 [migration/0]
    4 root      20   0     0    0    0 S  0.0  0.0   0:00.09 [ksoftirqd/0]

--
Zach Underwood (RHCE,RHCSA,RHCT)
My website [1]

My photes [2]

Links:
------
[1] http://zachunderwood.me
[2] http://zunder1990.openphoto.me

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium



--
Zach Underwood (RHCE,RHCSA,RHCT)

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium




--
Zach Underwood (RHCE,RHCSA,RHCT)
My website
My photes