Hi,

Thank you for the pointers.

To be more specific the page generation for an arista switch with 760 ports take 0.567 seconds.
But the loading of all graphs (a lot of sensors) take 8m 53s according to firebug.

Generating the ports view page takes 1.421s but loading all the graphs takes 12m 33s and 493 HTTP request (maybe not accurate as firebug says the log limit was reached).

On a force10 switch with 48 ports page generates in 0.207seconds and the page loads in 2.73s.
The ports view takes 0.311 seconds to generate and the page finishes loading graphs after 1m8s (205 HTTP requests in total).


So from what I understand the mysql speed might not be in cause but maybe the RRD disk I/O.
What can I do to speed it up ?
Moving the disk on faster storage will be enough ?

Could it be that apache need tuning to handle that amount of call to graph.php ?

For the record the disk system is an IBM V3700 SAS attached to the ESXi hosts.


Best regards,
Louis

January 9 2015 3:11 PM, "Tom Laermans" <tom.laermans@powersource.cx> wrote:

 

Hi,

You must note however, that the load time for the page as displayed by Observium is the generation time of the HTML (which is influenced by MySQL speed and CPU, mostly), which includes image tags to load the graphs - but not the loading of the graphs themselves (which is heavily influenced by both CPU and RRD Disk I/O).

Tom

On 01/09/2015 04:08 PM, Pedersen, Sean wrote:

 

It might help if you included a couple of references/examples of the pages that are slow. 

 

To give you something to compare against, we’re running Observium on an ESX VM – 4x Xeon X5690 @ 3.5GHz, 8GB RAM, no idea on storage – but we’re at a pretty consistent 40-50% utilization at all times, using about 2GB of RAM. This is with ~200 devices and 16K ports. 

 

I looked at a Cisco switch stack that has 115 active ports. Graphs > System loaded in .45 seconds, which is only 16 different graphs between four categories. Likewise, the Ports page loaded at .64 seconds with the miniature preview graphs. Clicking on a specific port, it loaded 24 graphs in .49 seconds. 

 

Now…I have some custom port lists, one of which is 36 graphs, which loaded in .53 seconds. However, I have another group that has…a metric shit-tonne of ports and graphs on it – hundreds of them. The page loaded in 1.07 seconds, but it took several seconds more for all of the individual graphs to populate, which I expect considering the sheer number of them present in that page. I don’t know if that’s simply the browser catching up, or if it’s still generating the actual graphs in the background.

 

From: Louis Bailleul <louis.bailleul@phangos.fr>
Reply-To: "observium@observium.org" <observium@observium.org>
Date: Friday, January 9, 2015 at 7:46 AM
To: "observium@observium.org" <observium@observium.org>
Subject: [Observium] Speed up graph rendering

 

Hi,

I am currently using Observium on 149 switches with a total of 10173 ports.
I can't say that anything is wrong with it, but the web interface seems a bit slow especially when you want to display pages with a lot of graphs.

Observium is currently running in a VM with 4 xeon E5-2650 cores and 3Gb of ram.
It's virtual disks are on a local raid5 composed of 10K SAS disks.

Observium report that it's VM use on average 25% of its CPUs with spikes at 40% when the web interface is heavily used.
The disk I/O doesn't go past 150 ops OUT and rare spikes at 50 IN.

Anyone could advise on what kind of hardware or software tweaking could help speed up the thing ?

Are they special requirements/tunnings for the rrd storage or the mysql database ?


Best regards,
Louis



 

Founded in 2007, IO provides the data center as a service to businesses and governments around the world.

The communication contained in this e-mail is confidential and is intended only for the named recipient(s) and may contain information that is privileged, proprietary, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. Please immediately notify the sender of the error, and delete this communication including any attached files from your system. Thank you for your cooperation.    

_______________________________________________

observium mailing list

observium@observium.org

http://postman.memetic.org/cgi-bin/mailman/listinfo/observium