php7.0-ldap works fine with AD integration

Regards

Christian

Från: observium <observium-bounces@observium.org> För Ming Wong, CLSA
Skickat: den 17 september 2018 15:30
Till: 'observium@observium.org' <observium@observium.org>
Ämne: Re: [Observium] Observium poller is becoming slow

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

From: Ming Wong, CLSA
Sent: Monday, September 17, 2018 5:36 PM
To: 'observium@observium.org' <observium@observium.org>
Subject: Observium poller is becoming slow

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

The content of this communication is intended for the recipient and is subject to CLSA Legal and Regulatory Notices.
These can be viewed at https://www.clsa.com/disclaimer.html or sent to you upon request.
Please consider before printing. CLSA is ISO14001 certified and committed to reducing its impact on the environment.