Have you tried to tune your mysql?<div><br></div><div>Try <a href="http://mysqltuner.pl">mysqltuner.pl</a>, it&#39;s on github.</div><div><br></div><div>Disable mysql query cache, it have a giant lock and generally slows down things instead of speeds up.<br></div><div><br></div><div>--</div><div>Eduardo Schoedler</div><div><br></div><div><br>Em quinta-feira, 28 de julho de 2016, Lyndon Labuschagne &lt;<a href="mailto:lyndonl@mobiletorque.co.za">lyndonl@mobiletorque.co.za</a>&gt; escreveu:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi<br>
Yes all up to date<br>
<br>
Is there any particular things I should be looking at / for, I have totally killed off the DB and it is currently building back up, discovering hosts etc<br>
a possible kick ass mysql config file or other hints<br>
<br>
<br>
root@observium:/opt/observium# svn update<br>
Updating &#39;.&#39;:<br>
At revision 8013.<br>
<br>
root@observium:/opt/observium# ./discovery.php -u<br>
<br>
  ___   _                              _<br>
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___<br>
| | | || &#39;_ \ / __| / _ \| &#39;__|\ \ / /| || | | || &#39;_ ` _ \<br>
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |<br>
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|<br>
                         Observium Professional 0.16.7.8003<br>
                                   <a href="http://www.observium.org" target="_blank">http://www.observium.org</a><br>
<br>
-- Database is up to date.<br>
<br>
<br>
&gt; On 28 Jul 2016, at 14:39, Adam Armstrong &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;adama@memetic.org&#39;)">adama@memetic.org</a>&gt; wrote:<br>
&gt;<br>
&gt; Hmm. I don&#39;t understand how they can be particularly slow. They&#39;re generally small tables.<br>
&gt;<br>
&gt; Are you sure that&#39;s running the latest version? The ports table UPDATE seems fairly short.<br>
&gt;<br>
&gt; adam.<br>
&gt;&gt; On 28/07/2016 09:06:42, Lyndon Labuschagne &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;lyndonl@mobiletorque.co.za&#39;)">lyndonl@mobiletorque.co.za</a>&gt; wrote:<br>
&gt;&gt;<br>
&gt;&gt; The continuing saga<br>
&gt;&gt;<br>
&gt;&gt; It seem that the &quot;processors-state” integration waits for a long time, most other queries / read / writes are being completed in under 5 seconds, as shown below these are “Waiting” for 40+ seconds, these seems to be linked to JOINS in most cases<br>
&gt;&gt; Does anyone have an idea on how to speed these up from a tuning perspective?<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; 8603 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;2740&#39;<br>
&gt;&gt; 8604 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;2554&#39;<br>
&gt;&gt; 8609 observium localhost observium 40 Query query en UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;2555&#39;<br>
&gt;&gt; 8610 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;2154&#39;<br>
&gt;&gt; 8611 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;1880&#39;<br>
&gt;&gt; 8612 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;1916&#39;<br>
&gt;&gt; 8627 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;1936&#39;<br>
&gt;&gt; 8629 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;2161&#39;<br>
&gt;&gt; 8633 observium localhost observium 40 Query Waiting UPDATE `processors-state` set `processor_usage` =&#39;0&#39;,`processor_polled` =&#39;1469691601&#39; WHERE `processor_id` = &#39;2596&#39;<br>
&gt;&gt; 8634 observium localhost observium 37 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;864&#39;<br>
&gt;&gt; 8637 observium localhost observium 35 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;956&#39;<br>
&gt;&gt; 8638 observium localhost observium 35 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;1073&#39;<br>
&gt;&gt; 8639 observium localhost observium 35 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;578&#39;<br>
&gt;&gt; 8640 observium localhost observium 35 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;513&#39;<br>
&gt;&gt; 8572 observium localhost observium 14 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;312&#39;<br>
&gt;&gt; 8630 observium localhost observium 14 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;430&#39;<br>
&gt;&gt; 8646 observium localhost observium 13 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;1099&#39;<br>
&gt;&gt; 8647 observium localhost observium 13 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;573&#39;<br>
&gt;&gt; 8613 observium localhost observium 12 Query Waiting UPDATE `mempools-state` set `mempool_polled` =&#39;1469691629&#39;,`mempool_used` =&#39;20824064&#39;,`mempool_perc` =&#39;32.73&#39;,`mempool_free` =&#39;42799104&#39;,`mempool_total` =&#39;63623168&#39; WHERE `mempool_id` = &#39;2359&#39;<br>
&gt;&gt; 8615 observium localhost observium 12 Query query en UPDATE `mempools-state` set `mempool_polled` =&#39;1469691629&#39;,`mempool_used` =&#39;27287552&#39;,`mempool_perc` =&#39;42.8&#39;,`mempool_free` =&#39;36466688&#39;,`mempool_total` =&#39;63754240&#39; WHERE `mempool_id` = &#39;1740&#39;<br>
&gt;&gt; 8628 observium localhost observium 12 Query Waiting UPDATE `mempools-state` set `mempool_polled` =&#39;1469691629&#39;,`mempool_used` =&#39;22896640&#39;,`mempool_perc` =&#39;35.93&#39;,`mempool_free` =&#39;40824832&#39;,`mempool_total` =&#39;63721472&#39; WHERE `mempool_id` = &#39;2273&#39;<br>
&gt;&gt; 8649 observium localhost observium 10 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;161&#39;<br>
&gt;&gt; 8650 observium localhost observium 10 Query Waiting SELECT `processors`.*, `processors-state`.`processor_usage`, `processors-state`.`processor_polled` FROM `processors` LEFT JOIN `processors-state` USING(`processor_id`) WHERE `device_id` = &#39;847&#39;<br>
&gt;&gt; 8605 observium localhost observium 9 Query Waiting SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `device_id` = &#39;1191&#39;<br>
&gt;&gt; 8625 observium localhost observium 7 Query Waiting SELECT * FROM `mempools` LEFT JOIN `mempools-state` USING (`mempool_id`) WHERE `device_id` = &#39;1057&#39;<br>
&gt;&gt; 8597 observium localhost observium 6 Query query en UPDATE `sensors-state` set `sensor_value` =&#39;23.8&#39;,`sensor_event` =&#39;ok&#39;,`sensor_status` =&#39;&#39;,`sensor_last_change` =&#39;1469690416&#39;,`sensor_polled` =&#39;1469691635&#39; WHERE `sensor_id` = &#39;5102&#39;<br>
&gt;&gt; 8576 observium localhost observium 4 Query query en UPDATE `ports` set `poll_time` =&#39;1469691627&#39;,`poll_period` =&#39;703&#39;,`ifInOctets` =&#39;88925&#39;,`ifInOctets_rate` =&#39;0&#39;,`ifOutOctets` =&#39;88925&#39;,`ifOutOctets_rate` =&#39;0&#39;,`ifInErrors` =&#39;0&#39;,`ifInErrors_rate` =&#39;0&#39;,`ifInErrors_delta` =&#39;0&#39;,`ifOutErrors` =&#39;0&#39;,`ifOutErrors_rate`<br>
&gt;&gt; 7746 observium localhost observium 2 Query query en INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES (&#39;701&#39;,&#39;205&#39;,&#39;13401&#39;,&#39;84b59cb47383&#39;,&#39;learned&#39;)<br>
&gt;&gt; 8428 observium localhost observium 2 Query query en UPDATE `ports` set `poll_time` =&#39;1469691592&#39;,`poll_period` =&#39;328&#39;,`ifInOctets` =&#39;0&#39;,`ifInOctets_rate` =&#39;0&#39;,`ifOutOctets` =&#39;0&#39;,`ifOutOctets_rate` =&#39;0&#39;,`ifInErrors` =&#39;0&#39;,`ifInErrors_rate` =&#39;0&#39;,`ifInErrors_delta` =&#39;0&#39;,`ifOutErrors` =&#39;0&#39;,`ifOutErrors_rate` =&#39;0&#39;,`i<br>
&gt;&gt;<br>
&gt;&gt; 411 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2708&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 421 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2404&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 423 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2119&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 425 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2004&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 426 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2287&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 429 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2888&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 431 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2875&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 432 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2661&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 433 observium localhost observium 24 Query query en INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2759&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 434 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2455&#39;,&#39;22&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 435 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2982&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 436 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2120&#39;,&#39;1&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 437 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2452&#39;,&#39;30&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 439 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;1926&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 441 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2447&#39;,&#39;36&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 450 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2986&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 451 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2267&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 454 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2937&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 456 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;3006&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 457 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2916&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 458 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2358&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 459 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2825&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 460 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2332&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 471 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;1866&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 478 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2121&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt; 482 observium localhost observium 24 Query Waiting INSERT INTO `processors-state` (`processor_id`,`processor_usage`,`processor_polled`) VALUES (&#39;2549&#39;,&#39;0&#39;,&#39;1469692947&#39;)<br>
&gt;&gt;<br>
&gt;&gt; &gt; On 25 Jul 2016, at 11:35, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; This is a walk from the Server that is running at a decent poller speed<br>
&gt;&gt; &gt; It complains about LM-SENSORS-MIB, and yet the MIB exists, and is identical to the other servers file, the other server seems fine and does not show any errors but is much slower on polling<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; What I also find interesting although possibly nothing is that the returned details are quoted in “ “ on the server that is can’t find the LM-SENSORS-MIB Ubuntu 16.04<br>
&gt;&gt; &gt; The old server which is running fine, is Ubuntu 15.04<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; Both use snmpd version 5.7.3<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; snmpwalk -v1 -c SNMPKEY domain.name.tld .1.3.6.1.2.1.1<br>
&gt;&gt; &gt; MIB search path: /opt/observium/mibs<br>
&gt;&gt; &gt; Cannot find module (LM-SENSORS-MIB): At line 1 in (none)<br>
&gt;&gt; &gt; SNMPv2-MIB::sysDescr.0 = STRING: Linux 2.6.32.65 #1 Thu Jul 16 11:50:24 EEST 2015 mips<br>
&gt;&gt; &gt; SNMPv2-MIB::sysObjectID.0 = OID: SNMPv2-SMI::enterprises.41112.1.4<br>
&gt;&gt; &gt; DISMAN-EVENT-MIB::sysUpTimeInstance = Timeticks: (543994600) 62 days, 23:05:46.00<br>
&gt;&gt; &gt; SNMPv2-MIB::sysContact.0 = STRING: networks<br>
&gt;&gt; &gt; SNMPv2-MIB::sysName.0 = STRING: domain.name.tld<br>
&gt;&gt; &gt; SNMPv2-MIB::sysLocation.0 = STRING: Some GPS Location<br>
&gt;&gt; &gt; SNMPv2-MIB::sysServices.0 = INTEGER: 79<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORLastChange.0 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORIndex.1 = INTEGER: 1<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORIndex.2 = INTEGER: 2<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORIndex.3 = INTEGER: 3<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORIndex.4 = INTEGER: 4<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORIndex.5 = INTEGER: 5<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORID.1 = OID: SNMPv2-MIB::snmpMIB<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORID.2 = OID: iso.2.840.10036<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORID.3 = OID: IF-MIB::ifMIB<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORID.4 = OID: SNMPv2-SMI::enterprises.10002.1.1.1.31<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORID.5 = OID: SNMPv2-SMI::enterprises.41112<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORDescr.1 = STRING: The MIB module for SNMP entities<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORDescr.2 = STRING: The MIB module for IEEE 802.11 entities.<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORDescr.3 = STRING: The MIB module to describe generic objects for network interface sub-layers<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORDescr.4 = STRING: The MIB module to describe system resources<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORDescr.5 = STRING: Ubiquiti Networks MIB module<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORUpTime.1 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORUpTime.2 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORUpTime.3 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORUpTime.4 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; SNMPv2-MIB::sysORUpTime.5 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; - Server that is showing issues<br>
&gt;&gt; &gt; snmpwalk -v1 -c SNMPKEY domain.name.tld .1.3.6.1.2.1.1<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.1.0 = STRING: &quot;Linux 2.6.32.65 #1 Thu Jul 16 11:50:24 EEST 2015 mips&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.2.0 = OID: iso.3.6.1.4.1.41112.1.4<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.3.0 = Timeticks: (543981700) 62 days, 23:03:37.00<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.4.0 = STRING: &quot;networks&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.5.0 = STRING: &quot;domain.name.tld&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.6.0 = STRING: &quot;Some GPS Location&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.7.0 = INTEGER: 79<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.8.0 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.1.1 = INTEGER: 1<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.1.2 = INTEGER: 2<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.1.3 = INTEGER: 3<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.1.4 = INTEGER: 4<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.1.5 = INTEGER: 5<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.2.1 = OID: iso.3.6.1.6.3.1<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.2.2 = OID: iso.2.840.10036<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.2.3 = OID: iso.3.6.1.2.1.31<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.2.4 = OID: iso.3.6.1.4.1.10002.1.1.1.31<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.2.5 = OID: iso.3.6.1.4.1.41112<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.3.1 = STRING: &quot;The MIB module for SNMP entities&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.3.2 = STRING: &quot;The MIB module for IEEE 802.11 entities.&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.3.3 = STRING: &quot;The MIB module to describe generic objects for network interface sub-layers&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.3.4 = STRING: &quot;The MIB module to describe system resources&quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.3.5 = STRING: &quot;Ubiquiti Networks MIB module &quot;<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.4.1 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.4.2 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.4.3 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.4.4 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt; iso.3.6.1.2.1.1.9.1.4.5 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt;&gt; On 25 Jul 2016, at 09:00, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; May not betheDB after all most of the SQL RUNTIME stats are 0.000xxxx so its probably not<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; found this in debug mode<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; It seems the poller / mib is freaking out about &quot;Reason: (noSuchName) There is no such dns.name.tld variable name in this MIB.&quot;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; the device is reachable via SNMP as shown in a portion of the snmpwalk below<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; this is where I am seeing the slowing down during the ifindex scanning as previously posted<br>
&gt;&gt; &gt;&gt;&gt;&gt; if I poll a radio, Ubiquiti Airfibre/ M5 . Rocket etc it seems to be slow, even when the radio is directly connected to the hosting switch as a test.<br>
&gt;&gt; &gt;&gt;&gt;&gt; The issue pops up when doing the ifindex - ifIndex: 1 2 3 5 6 7 8 9 (that takes 40 to 50 seconds)<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[UPDATE `snmp_errors` set `error_count` =&#39;148&#39;,`updated` =&#39;1469428547&#39; WHERE `error_id` = &#39;6645&#39;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00229788s]<br>
&gt;&gt; &gt;&gt; SNMP STATUS[FALSE]<br>
&gt;&gt; &gt;&gt; 6<br>
&gt;&gt; &gt;&gt; CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp &#39;udp&#39;:&#39;dns.name.tld&#39;:&#39;161&#39; ifInMulticastPkts.6 ifOutMulticastPkts.6 ifInBroadcastPkts.6 ifOutBroadcastPkts.6 ifHCInOctets.6 ifHCOutOctets.6 ifHCInUcastPkts.6 ifHCOutUcastPkts.6 ifHCInMulticastPkts.6 ifHCOutMulticastPkts.6 ifHCInBroadcastPkts.6 ifHCOutBroadcastPkts.6 ifInOctets.6 ifOutOctets.6 ifInUcastPkts.6 ifOutUcastPkts.6 ifInNUcastPkts.6 ifOutNUcastPkts.6 ifInDiscards.6 ifOutDiscards.6 ifInErrors.6 ifOutErrors.6 ifInUnknownProtos.6 ifMtu.6 ifSpeed.6 ifPhysAddress.6 ifAdminStatus.6 ifLastChange.6 ifPromiscuousMode.6 ifConnectorPresent.6]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; CMD EXITCODE[1]<br>
&gt;&gt; &gt;&gt; CMD RUNTIME[6.0817s]<br>
&gt;&gt; &gt;&gt; STDOUT[<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; ]<br>
&gt;&gt; &gt;&gt; STDERR[<br>
&gt;&gt; &gt;&gt; Error in packet<br>
&gt;&gt; &gt;&gt; Reason: (noSuchName) There is no such variable name in this MIB.<br>
&gt;&gt; &gt;&gt; Failed object: ifInMulticastPkts.6<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; Timeout: No Response from udp:dns.name.tld:161.<br>
&gt;&gt; &gt;&gt; ]<br>
&gt;&gt; &gt;&gt; SNMP ERROR[#1002 - Request timeout]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = &#39;27&#39; AND `error_code` = &#39;1002&#39; AND `snmp_cmd` = &#39;snmpget&#39; AND `snmp_options` = &#39;-OQUs&#39; AND `mib` = &#39;IF-MIB&#39; AND `oid` = &#39;ifInMulticastPkts.6 ifOutMulticastPkts.6 ifInBroadcastPkts.6 ifOutBroadcastPkts.6 ifHCInOctets.6 ifHCOutOctets.6 ifHCInUcastPkts.6 ifHCOutUcastPkts.6 ifHCInMulticastPkts.6 ifHCOutMulticastPkts.6 ifHCInBroadcastPkts.6 ifHCOutBroadcastPkts.6 ifInOctets.6 ifOutOctets.6 ifInUcastPkts.6 ifOutUcastPkts.6 ifInNUcastPkts.6 ifOutNUcastPkts.6 ifInDiscards.6 ifOutDiscards.6 ifInErrors.6 ifOutErrors.6 ifInUnknownProtos.6 ifMtu.6 ifSpeed.6 ifPhysAddress.6 ifAdminStatus.6 ifLastChange.6 ifPromiscuousMode.6 ifConnectorPresent.6&#39;;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00058079s]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[UPDATE `snmp_errors` set `error_count` =&#39;148&#39;,`updated` =&#39;1469428553&#39; WHERE `error_id` = &#39;6650&#39;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00175095s]<br>
&gt;&gt; &gt;&gt; SNMP STATUS[FALSE]<br>
&gt;&gt; &gt;&gt; 7<br>
&gt;&gt; &gt;&gt; CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp &#39;udp&#39;:&#39;dns.name.tld&#39;:&#39;161&#39; ifInMulticastPkts.7 ifOutMulticastPkts.7 ifInBroadcastPkts.7 ifOutBroadcastPkts.7 ifHCInOctets.7 ifHCOutOctets.7 ifHCInUcastPkts.7 ifHCOutUcastPkts.7 ifHCInMulticastPkts.7 ifHCOutMulticastPkts.7 ifHCInBroadcastPkts.7 ifHCOutBroadcastPkts.7 ifInOctets.7 ifOutOctets.7 ifInUcastPkts.7 ifOutUcastPkts.7 ifInNUcastPkts.7 ifOutNUcastPkts.7 ifInDiscards.7 ifOutDiscards.7 ifInErrors.7 ifOutErrors.7 ifInUnknownProtos.7 ifMtu.7 ifSpeed.7 ifPhysAddress.7 ifAdminStatus.7 ifLastChange.7 ifPromiscuousMode.7 ifConnectorPresent.7]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; CMD EXITCODE[1]<br>
&gt;&gt; &gt;&gt; CMD RUNTIME[6.0846s]<br>
&gt;&gt; &gt;&gt; STDOUT[<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; ]<br>
&gt;&gt; &gt;&gt; STDERR[<br>
&gt;&gt; &gt;&gt; Error in packet<br>
&gt;&gt; &gt;&gt; Reason: (noSuchName) There is no such variable name in this MIB.<br>
&gt;&gt; &gt;&gt; Failed object: ifInMulticastPkts.7<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; Timeout: No Response from udp:dns.name.tld:161.<br>
&gt;&gt; &gt;&gt; ]<br>
&gt;&gt; &gt;&gt; SNMP ERROR[#1002 - Request timeout]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = &#39;27&#39; AND `error_code` = &#39;1002&#39; AND `snmp_cmd` = &#39;snmpget&#39; AND `snmp_options` = &#39;-OQUs&#39; AND `mib` = &#39;IF-MIB&#39; AND `oid` = &#39;ifInMulticastPkts.7 ifOutMulticastPkts.7 ifInBroadcastPkts.7 ifOutBroadcastPkts.7 ifHCInOctets.7 ifHCOutOctets.7 ifHCInUcastPkts.7 ifHCOutUcastPkts.7 ifHCInMulticastPkts.7 ifHCOutMulticastPkts.7 ifHCInBroadcastPkts.7 ifHCOutBroadcastPkts.7 ifInOctets.7 ifOutOctets.7 ifInUcastPkts.7 ifOutUcastPkts.7 ifInNUcastPkts.7 ifOutNUcastPkts.7 ifInDiscards.7 ifOutDiscards.7 ifInErrors.7 ifOutErrors.7 ifInUnknownProtos.7 ifMtu.7 ifSpeed.7 ifPhysAddress.7 ifAdminStatus.7 ifLastChange.7 ifPromiscuousMode.7 ifConnectorPresent.7&#39;;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00056005s]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[UPDATE `snmp_errors` set `error_count` =&#39;148&#39;,`updated` =&#39;1469428559&#39; WHERE `error_id` = &#39;6656&#39;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00169611s]<br>
&gt;&gt; &gt;&gt; SNMP STATUS[FALSE]<br>
&gt;&gt; &gt;&gt; 8<br>
&gt;&gt; &gt;&gt; CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp &#39;udp&#39;:&#39;dns.name.tld&#39;:&#39;161&#39; ifInMulticastPkts.8 ifOutMulticastPkts.8 ifInBroadcastPkts.8 ifOutBroadcastPkts.8 ifHCInOctets.8 ifHCOutOctets.8 ifHCInUcastPkts.8 ifHCOutUcastPkts.8 ifHCInMulticastPkts.8 ifHCOutMulticastPkts.8 ifHCInBroadcastPkts.8 ifHCOutBroadcastPkts.8 ifInOctets.8 ifOutOctets.8 ifInUcastPkts.8 ifOutUcastPkts.8 ifInNUcastPkts.8 ifOutNUcastPkts.8 ifInDiscards.8 ifOutDiscards.8 ifInErrors.8 ifOutErrors.8 ifInUnknownProtos.8 ifMtu.8 ifSpeed.8 ifPhysAddress.8 ifAdminStatus.8 ifLastChange.8 ifPromiscuousMode.8 ifConnectorPresent.8]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; CMD EXITCODE[1]<br>
&gt;&gt; &gt;&gt; CMD RUNTIME[6.0792s]<br>
&gt;&gt; &gt;&gt; STDOUT[<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; ]<br>
&gt;&gt; &gt;&gt; STDERR[<br>
&gt;&gt; &gt;&gt; Error in packet<br>
&gt;&gt; &gt;&gt; Reason: (noSuchName) There is no such variable name in this MIB.<br>
&gt;&gt; &gt;&gt; Failed object: ifInMulticastPkts.8<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; Timeout: No Response from udp:dns.name.tld:161.<br>
&gt;&gt; &gt;&gt; ]<br>
&gt;&gt; &gt;&gt; SNMP ERROR[#1002 - Request timeout]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = &#39;27&#39; AND `error_code` = &#39;1002&#39; AND `snmp_cmd` = &#39;snmpget&#39; AND `snmp_options` = &#39;-OQUs&#39; AND `mib` = &#39;IF-MIB&#39; AND `oid` = &#39;ifInMulticastPkts.8 ifOutMulticastPkts.8 ifInBroadcastPkts.8 ifOutBroadcastPkts.8 ifHCInOctets.8 ifHCOutOctets.8 ifHCInUcastPkts.8 ifHCOutUcastPkts.8 ifHCInMulticastPkts.8 ifHCOutMulticastPkts.8 ifHCInBroadcastPkts.8 ifHCOutBroadcastPkts.8 ifInOctets.8 ifOutOctets.8 ifInUcastPkts.8 ifOutUcastPkts.8 ifInNUcastPkts.8 ifOutNUcastPkts.8 ifInDiscards.8 ifOutDiscards.8 ifInErrors.8 ifOutErrors.8 ifInUnknownProtos.8 ifMtu.8 ifSpeed.8 ifPhysAddress.8 ifAdminStatus.8 ifLastChange.8 ifPromiscuousMode.8 ifConnectorPresent.8&#39;;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00071502s]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; SQL[UPDATE `snmp_errors` set `error_count` =&#39;148&#39;,`updated` =&#39;1469428565&#39; WHERE `error_id` = &#39;6662&#39;]<br>
&gt;&gt; &gt;&gt; SQL RUNTIME[0.00218582s]<br>
&gt;&gt; &gt;&gt; SNMP STATUS[FALSE]<br>
&gt;&gt; &gt;&gt; 9<br>
&gt;&gt; &gt;&gt; CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp &#39;udp&#39;:&#39;dns.name.tld&#39;:&#39;161&#39; ifInMulticastPkts.9 ifOutMulticastPkts.9 ifInBroadcastPkts.9 ifOutBroadcastPkts.9 ifHCInOctets.9 ifHCOutOctets.9 ifHCInUcastPkts.9 ifHCOutUcastPkts.9 ifHCInMulticastPkts.9 ifHCOutMulticastPkts.9 ifHCInBroadcastPkts.9 ifHCOutBroadcastPkts.9 ifInOctets.9 ifOutOctets.9 ifInUcastPkts.9 ifOutUcastPkts.9 ifInNUcastPkts.9 ifOutNUcastPkts.9 ifInDiscards.9 ifOutDiscards.9 ifInErrors.9 ifOutErrors.9 ifInUnknownProtos.9 ifMtu.9 ifSpeed.9 ifPhysAddress.9 ifAdminStatus.9 ifLastChange.9 ifPromiscuousMode.9 ifConnectorPresent.9]<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; CMD EXITCODE[1]<br>
&gt;&gt; &gt;&gt; CMD RUNTIME[6.0803s]<br>
&gt;&gt; &gt;&gt; STDOUT[<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; This is a manual snmpwalk<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; root@observium:~# snmpwalk -v1 -c SNMP-KEY dns.name.tld<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.1.0 = STRING: &quot;Linux 2.6.32.65 #1 Thu Jul 16 11:50:24 EEST 2015 mips&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.2.0 = OID: iso.3.6.1.4.1.41112.1.4<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.3.0 = Timeticks: (543077500) 62 days, 20:32:55.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.4.0 = STRING: &quot;networks&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.5.0 = STRING: &quot;vdns.name.tld&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.6.0 = STRING: “Some GPS Co Ords&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.7.0 = INTEGER: 79<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.8.0 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.1.1 = INTEGER: 1<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.1.2 = INTEGER: 2<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.1.3 = INTEGER: 3<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.1.4 = INTEGER: 4<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.1.5 = INTEGER: 5<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.2.1 = OID: iso.3.6.1.6.3.1<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.2.2 = OID: iso.2.840.10036<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.2.3 = OID: iso.3.6.1.2.1.31<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.2.4 = OID: iso.3.6.1.4.1.10002.1.1.1.31<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.2.5 = OID: iso.3.6.1.4.1.41112<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.3.1 = STRING: &quot;The MIB module for SNMP entities&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.3.2 = STRING: &quot;The MIB module for IEEE 802.11 entities.&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.3.3 = STRING: &quot;The MIB module to describe generic objects for network interface sub-layers&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.3.4 = STRING: &quot;The MIB module to describe system resources&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.3.5 = STRING: &quot;Ubiquiti Networks MIB module &quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.4.1 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.4.2 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.4.3 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.4.4 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.1.9.1.4.5 = Timeticks: (9956100) 1 day, 3:39:21.00<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.1.0 = INTEGER: 9<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.1 = INTEGER: 1<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.2 = INTEGER: 2<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.3 = INTEGER: 3<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.4 = INTEGER: 4<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.5 = INTEGER: 5<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.6 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.7 = INTEGER: 7<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.8 = INTEGER: 8<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.1.9 = INTEGER: 9<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.1 = STRING: &quot;lo&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.2 = STRING: &quot;eth0&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.3 = STRING: &quot;eth1&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.4 = STRING: &quot;wifi0&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.5 = STRING: &quot;ath0&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.6 = STRING: &quot;eth0.36&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.7 = STRING: &quot;ath0.36&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.8 = STRING: &quot;br0&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.2.9 = STRING: &quot;br1&quot;<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.1 = INTEGER: 24<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.2 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.3 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.4 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.5 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.6 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.7 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.8 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.3.9 = INTEGER: 6<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.1 = INTEGER: 16436<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.2 = INTEGER: 2020<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.3 = INTEGER: 1500<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.4 = INTEGER: 2286<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.5 = INTEGER: 2020<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.6 = INTEGER: 2020<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.7 = INTEGER: 2020<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.8 = INTEGER: 2020<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.4.9 = INTEGER: 2020<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.1 = Gauge32: 0<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.2 = Gauge32: 100000000<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.3 = Gauge32: 0<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.4 = Gauge32: 0<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.5 = Gauge32: 0<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.6 = Gauge32: 100000000<br>
&gt;&gt; &gt;&gt; iso.3.6.1.2.1.2.2.1.5.7 = Gauge32: 0<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt; On 25 Jul 2016, at 07:24, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt; Im going to fire up the server again today and test more, will let you know,<br>
&gt;&gt; &gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt; if there anyway of running the poller and but not writing to the DB, I see there is a flag to disable the writing of RRDs, I want to see if the poller performance is the issue, the disk I/O or the DB<br>
&gt;&gt; &gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 25 Jul 2016, at 00:30, Adam Armstrong wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; If do you have sufficient buffers and caching for innodb in mysql?<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; We have some /very/ large installs which saw little impact from the changes.<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Adam.<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Sent from BlueMail<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 24 Jul 2016, at 20:55, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt; I have been performance tuning all day with little to no affect<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; its just very strange how a XEN VM out performs bare metal, it may also be Ubuntu 16.04 as that is on the bare metal server and 15.04 is on the VM<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 24 Jul 2016, at 21:47, Adam Armstrong wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; We&#39;ve changed the way the ports table works, removing memory tables.<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; It&#39;s likely that you now need more mysql resources, since were now writing to an innodb table instead of a memory table.<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Odd, really. It didn&#39;t seem to have a huge effect on my dev install or some other very large installs.<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Perhaps you could investigate mysql performance tuning? :)<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Adam.<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Sent from BlueMail<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 24 Jul 2016, at 19:58, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt; i went back<br>
&gt;&gt; &gt;&gt;&gt;&gt; to use the old database server on the VM and all was much better, running pollers at 10 to 15 seconds per device,<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; until I upgraded the db by using discovery -u<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; back in the same boat again<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 24 Jul 2016, at 09:56, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Ok if I poll a router / switch / server etc it seems to be ok,<br>
&gt;&gt; &gt;&gt;&gt;&gt; a full scan on a 7606 takes around 45 seconds,<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; if I poll a radio, Ubiquiti Airfibre/ M5 . Rocket etc it seems to be slow, even when the radio is directly connected to the hosting switch as a test.<br>
&gt;&gt; &gt;&gt;&gt;&gt; The issue pops up when doing the ifindex - ifIndex: 1 2 3 5 6 7 8 9 (that takes 40 to 50 seconds)<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; o Caching Oids ifDescr ifType ifOperStatus ifAlias ifName ifHighSpeed ifInMulticastPkts ifOutMulticastPkts ifInBroadcastPkts ifOutBroadcastPkts<br>
&gt;&gt; &gt;&gt;&gt;&gt; ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifHCInMulticastPkts ifHCOutMulticastPkts ifHCInBroadcastPkts<br>
&gt;&gt; &gt;&gt;&gt;&gt; ifHCOutBroadcastPkts ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInNUcastPkts ifOutNUcastPkts ifInDiscards ifOutDiscards ifInErrors ifOutErrors ifInUnknownProtos ifMtu ifSpeed ifPhysAddress ifAdminStatus ifLastChange ifPromiscuousMode ifConnectorPresent, ifIndex: 1 2 3 5 6 7 8 9 ADSL-LINE-MIB EtherLike-MIB dot3StatsDuplexStatus<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; The the other thing that had changed is that I was running a slightly older version of Observium on the VM server, still in the 79xx range not the 8003 version<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 24 Jul 2016, at 09:16, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; I know its bad form to reply to your own email but here is some more information re drive performance<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; root@observium:/opt/observium/rrd# hdparm -Tt /dev/mapper/observium--vg-root<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; /dev/mapper/observium--vg-root:<br>
&gt;&gt; &gt;&gt;&gt;&gt; Timing cached reads: 14428 MB in 2.00 seconds = 7218.63 MB/sec<br>
&gt;&gt; &gt;&gt;&gt;&gt; Timing buffered disk reads: 950 MB in 3.01 seconds<br>
&gt;&gt; &gt;&gt;&gt;&gt; = 315.94 MB/sec<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; root@observium:/opt/observium/rrd# dd if=/dev/zero of=/tmp/output bs=8k count=10k; rm -f /tmp/output<br>
&gt;&gt; &gt;&gt;&gt;&gt; 10240+0 records in<br>
&gt;&gt; &gt;&gt;&gt;&gt; 10240+0 records out<br>
&gt;&gt; &gt;&gt;&gt;&gt; 83886080 bytes (84 MB, 80 MiB) copied, 0.125735 s, 667 MB/s<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; On 24 Jul 2016, at 09:13, Lyndon Labuschagne wrote:<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Hi All<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; I have moved from a VM server to a physical server. as the VM was taking a bit of a pounding, graph dropouts etc<br>
&gt;&gt; &gt;&gt;&gt;&gt; The physical server is a dual quad core Xeon, 2.66Ghz with 128GB of RAM and a 32GB ramdisk, and rrdcache I also have 2.5TB or SAS storage in a raid6 config<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Will all of this my average poller-wrapper time is around 60 to 70 seconds per device<br>
&gt;&gt; &gt;&gt;&gt;&gt; if I manually run an snmpwalk a single device takes around 6 seconds<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; I have also disabled the ramdisk, rrdcached etc and I am not seeing much of a difference either way<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; I have around 900 devices and the VM server was way<br>
&gt;&gt; &gt;&gt;&gt;&gt; faster, any idea where to start looking for a bottleneck?<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; Regards<br>
&gt;&gt; &gt;&gt;&gt;&gt; Lyndon<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; _______________________________________________<br>
&gt;&gt; &gt;&gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;&gt;<br>
&gt;&gt; &gt;&gt;&gt; _______________________________________________<br>
&gt;&gt; &gt;&gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;&gt;<br>
&gt;&gt; &gt;&gt; _______________________________________________<br>
&gt;&gt; &gt;&gt; observium mailing list<br>
&gt;&gt; &gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt; &gt;<br>
&gt;&gt; &gt; _______________________________________________<br>
&gt;&gt; &gt; observium mailing list<br>
&gt;&gt; &gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; &gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt;&gt;<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; observium mailing list<br>
&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt;&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
&gt; _______________________________________________<br>
&gt; observium mailing list<br>
&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
&gt; <a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
<br>
_______________________________________________<br>
observium mailing list<br>
<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;observium@observium.org&#39;)">observium@observium.org</a><br>
<a href="http://postman.memetic.org/cgi-bin/mailman/listinfo/observium" target="_blank">http://postman.memetic.org/cgi-bin/mailman/listinfo/observium</a><br>
</blockquote></div><br><br>-- <br><div dir="ltr">Eduardo Schoedler<br></div><br>