Hi Markus,

 

Thanks for the reply.  Below are details the setup:

 

The Observium is on a VM running RH7.    It has 4 Xeon vCPU, 8G memory, and 100GB local disk.   90 devices are being monitored, and the polling interval is 1 minute.  RRDCache is enabled.

 

Software versions are Observium CE 18.9.9420, PHP 5.6.37, RRDtool 1.6.0, Mariadb 10.3.9 and  RRDCache 1.6.0.   The reason for running PHP 5 instead of PHP7 is to integrate with LDAP.

 

Below is the polling summary.   SQL takes 32.47% of the time.

 

#####  Completed polling run at 2018-09-17 16:01:36  #####

o Devices Polled       1

o Poller Time          53.21 secs

o Memory usage         20.5MB (peak: 22.5MB)

o MySQL Usage          Insert[1/0.035s] Update[1243/10.366s] Delete[1/0.017s] Cell[6/0.062s] Row[1115/6.065s] Rows[119/0.683s]

                        Col[4/0.051s](17.277s 32.47%)

o RRDTool Usage        update[1255/9.493s] (9.493s 17.84%)

o SNMP Usage           snmpget[13/3.125s] snmpwalk[16/8.485s] (11.61s 21.82%)

 

Thanks a lot,

Ming

 

 

Hi,

 

The polling time for each device is becoming long when more and more devices added to Observium.   From the poller debug output most of the time is spent on SQL update.    For a network switch, each port will trigger a SQL update.

 

Is it possible for Observium to poll all ports first, and then have a single SQL update statement covering all ports ?  Any advice in enhancing the polling speed or database performance ?

 

Thanks and regards,

Ming