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.cxwrote:
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/**observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
______________________________**_________________ observium mailing list observium@observium.org http://postman.memetic.org/**cgi-bin/mailman/listinfo/**observiumhttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Zach Underwood (RHCE,RHCSA,RHCT) My website http://zachunderwood.me My photes http://zunder1990.openphoto.me
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium