alter table devices_attribs add key device_id(device_id);
alter table alert_table add key dev_id(device_id);
I believe these are the two new indexes he added.
Kind Regards
Alastair
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: 09 January 2015 17:00
To: Observium Network Observation System
Subject: Re: [Observium] Speed up graph rendering
What indexes did he create?
adam.
------ Original Message ------
From: "Alastair Chamorro" <Alastair.Chamorro@voip-unlimited.net>
To: "Observium Network Observation System" <observium@observium.org>
Sent: 1/9/2015 9:00:09 AM
Subject: Re: [Observium] Speed up graph rendering
Hi Louis,
We had a similar issue where observium was falling over due to the amount of hosts we are monitoring and so it was alarming on everything all the time as the polls werent dealt with quick enough.
Our DBA moved the mySQL and RRD files to different volumes to spread the load on the drives. He also sorted an indexing issue on the mySQL side.
How many spindles do you have servicing the array? And what caching policy are you using on the RAID controller?
Alastair
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Louis Bailleul
Sent: 09 January 2015 14:46
To: 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
The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.
The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium