Hi Graf,
Can you turn on sql profiling (it’ll be in the options, probably under ui or debugging) and show the slowest queries?
The bottom right of the screen, there should be a database icon that’ll show this.
Beyond this MySQL/web benefits from being on a system with faster cores. MySQL and web generation is single threaded, so finding a system with the fastest individual cores for the web ui and database (and RRDs) can be a big improvement.
2.5ghz is snail speed :)
Adam.
Sent from my iPhone
On 31 Mar 2022, at 07:22, Graf Vincent via observium observium@observium.org wrote:
Hello,
Although I double check every tuning guide from the website, I’m in trouble with my Observium installation. First of all, the size of the network is huge… From the Statistics on about page :
1023 Devices57K Ports51K Sensors128 GB RRD20GB DBI run the latest version of Observium with PHP 7.3 on a Debian 10 physical server. It is a dual Intel Xeon 6248 2.5Ghz (20C/40T) equipped with 3 RAID groups :
RAID1 for the OSRAID1 for the RRD files and Observium applicationRAID5 for the databaseAll the disks are SSD.
The number of poller is set to 48 and the whole polling time has an average of 264s and a max of @334s (I just increase the poller to 60 today…).
I do housekeeping every week to cut off the event log and other stuff older than 30 days. I also use fast userspace caching with php-apcu For the port discovery, some of ports are ignored like vlans, control plan, stack interface, voice-port, etc…
The installation runs like a big diesel machine … not so fast but very robust.
My problem is that it takes more than 30 seconds to get the detail of simple 48 ports switch … and much more when I try to load a detailed backbone with many more ports.
Do you have any suggestion to improve the GUI responsiveness ?
Thank you for your time Kind regards Vincent
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium