Yeah, that might not very easy :) Anyhow, I'm pretty sure the majority of the slowness in your web gui is due to php rendering as you probably have a lot of stuff in the UI. PHP7 greatly improves this.
/Markus
2016-02-15 17:19 GMT+01:00 Louis Bailleul Louis.Bailleul@pgs.com:
Hi,
Thanks Markus, I’ll give it a go.
But I’ll have to work out how to get php7 on a Centos 7.
Best regards,
Louis
*From:* observium [mailto:observium-bounces@observium.org] *On Behalf Of *Markus Klock *Sent:* Monday, February 15, 2016 16:04 *To:* Observium Network Observation System *Subject:* Re: [Observium] Speeding up caching and database
Hey, I had the same problem.
I solved it by upgrading to PHP7, wrote a post about it here: http://blog.best-practice.se/2015/12/vastly-improve-observium-performance.ht... https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.best-2Dpractice.se_2015_12_vastly-2Dimprove-2Dobservium-2Dperformance.html&d=BQMFaQ&c=KV_I7O14pmwRcmAVyJ1eg4Jwb8Y2JAxuL5YgMGHpjcQ&r=FTXmt89oLXmbXfP78w86-PxB1XdLYgxG8hEoAnZvCvs&m=uaXDSth1ChgaFGcGXkisvfhjxcX7DJHnHBPFYO5K8Ww&s=obGrghSu50Kbkly1RUclAAn3o3Bo0Ny-ZyJ-rBB2n-0&e=
/Markus
2016-02-15 16:57 GMT+01:00 Louis Bailleul Louis.Bailleul@pgs.com:
Hi Team,
I have a performance issue with the web interface.
My Observium is monitoring 3095 devices from which 168 are switches (Just a bit less than 20000 ports total).
My server is an IBM X3650 M4, 32G of ram, 6 cores and a raid 10 of SSD.
I am more than happy with the polling performance has it finishing in under 200seconds.
But the web interface is quite annoying : I have a minimum Time to first bit of ~2seconds.
Once these two seconds have passed the page load almost instantly, graphs included.
So the question is, can I speed things up ?
And if yes how ?
It looks like Observium is spending about a second in the database and says that the Cache took 2 seconds to process (?).
Do I have some leverage on these points to make it faster ?
Page load time (Just a device page) :
Connection Setup TIME
Queueing 5.24 ms
Stalled 1.26 ms
Request sent 0.80 ms
Waiting (TTFB) *3.29 s*
Content Download 26.62 ms
Explanation 3.33 s
Observium Performance report :
*Page*
2.281s
*Cache*
2.047s
*MySQL*
*Cell*
50/0.0633s
*Row*
35/0.0113s
*Rows*
49/0.7822s
*Column*
8/0.0564s
*Memory*
*Cached*
180MB
*Page*
189MB
*Peak*
229MB
Versions:
*Observium*
0.16.1.7535 (27th January 2016)
*OS*
Linux 3.10.0-327.el7.x86_64 [amd64] (CentOS 7.2.1511)
*Apache*
2.4.6 (CentOS) PHP/5.4.16
*PHP*
5.4.16
*Python*
2.7.5
*MySQL*
5.5.44-MariaDB-log (extension: mysqli 5.5.44-MariaDB)
*SNMP*
NET-SNMP 5.7.2
*RRDtool*
1.4.8
Stats :
Statistics
*DB size*
606MB
*RRD size*
134GB
*Devices*
3095
*Ports*
19390
*IPv4 Addresses*
6148
*IPv4 Networks*
44
*IPv6 Addresses*
2959
*IPv6 Networks*
1
*Services*
0
*Applications*
0
*Processors*
61262
*Memory*
15563
*Storage*
11742
*Disk I/O*
97461
*HR-MIB*
96815
*Entity-MIB*
7292
*Syslog Entries*
0
*Eventlog Entries*
172938
*Sensors*
3863
*Toner*
Mysqltuner output :
-------- Performance Metrics
[--] Up for: 2d 21h 57m 9s (260M q [1K qps], 5K conn, TX: 283B, RX: 45B)
[--] Reads / Writes: 59% / 41%
[--] Binary logging is disabled
[--] Total buffers: 10.5G global + 4.7M per thread (650 max threads)
[OK] Maximum reached memory usage: 11.2G (35.94% of installed RAM)
[OK] Maximum possible memory usage: 13.5G (43.37% of installed RAM)
[OK] Slow queries: 0% (14K/260M)
[OK] Highest usage of available connections: 21% (142/650)
[OK] Aborted connections: 0.00% (0/5477)
[OK] Query cache efficiency: 32.3% (74M cached / 230M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (129 temp sorts / 182K sorts)
[OK] Temporary tables created on disk: 0% (201 on disk / 112K total)
[OK] Thread cache hit rate: 97% (142 created / 5K connections)
[OK] Table cache hit rate: 102% (922 open / 896 opened)
[OK] Open file limit used: 5% (52/1K)
[OK] Table locks acquired immediately: 97% (244M immediate / 249M locks)
-------- MyISAM Metrics
[!!] Key buffer used: 18.0% (28M used / 157M cache)
[OK] Key buffer size / total MyISAM indexes: 150.0M/99.0K
[!!] Read Key buffer hit rate: 93.3% (15 cached / 1 reads)
-------- InnoDB Metrics
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 8.0G/579.1M
[!!] InnoDB buffer pool instances: 1
[!!] InnoDB Used buffer: 6.67% (34952 used/ 524287 total)
[OK] InnoDB Read buffer efficiency: 100.00% (2079385726 hits/ 2079395120 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 11253445 writes)
-------- AriaDB Metrics
[--] AriaDB is disabled.
-------- Replication Metrics
[--] No replication slave(s) for this server.
[--] This is a standalone server..
-------- Recommendations
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance Remove Anonymous User accounts - there are 2 anonymous accounts. Set up a Password for user with the following SQL statement ( SETPASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
Set up a Secure Password for user@host ( SET PASSWORD FOR 'user'@'SpecificDNSorIp'= PASSWORD('secure_password'); )
Restrict Host for user@% to user@SpecificDNSorIpVariables to adjust:
innodb_buffer_pool_instances(=8)
Thanks.
Best regards,
Louis
*Louis Bailleul* *Computer Systems Engineer* Imaging & Engineering | Imaging
*Telephone: *+44 1932 376000 *Direct: *+44 1932 376842 *VOIP: *74416842 *Mobile: *+44 7786 525307 *Email: *louis.bailleul@pgs.com Louis.Bailleul@pgs.com
*A Clearer Image | www.pgs.com http://www.pgs.com *
*Address:* 4 The Heights, Brooklands, Weybridge, Surrey, KT13 0NY*, *United Kingdom
This e-mail, including any attachments and response string, may contain proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If you are not the intended recipient or transmission error has misdirected this e-mail, please notify the author by return e-mail and delete this message and any attachment immediately. If you are not the intended recipient you must not use, disclose, distribute, forward, copy, print or rely on this e-mail in any way except as permitted by the author.
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium https://urldefense.proofpoint.com/v2/url?u=http-3A__postman.memetic.org_cgi-2Dbin_mailman_listinfo_observium&d=BQMFaQ&c=KV_I7O14pmwRcmAVyJ1eg4Jwb8Y2JAxuL5YgMGHpjcQ&r=FTXmt89oLXmbXfP78w86-PxB1XdLYgxG8hEoAnZvCvs&m=uaXDSth1ChgaFGcGXkisvfhjxcX7DJHnHBPFYO5K8Ww&s=UklM65EovzyMnl0bxtm0jeNoM_cV09MzKAO9He18WIE&e=
http://www.pgs.com Louis Bailleul Computer Systems Engineer Imaging & Engineering | Imaging
Telephone: +44 1932 376000 Direct: +44 1932 376842 VOIP: 74416842 Mobile: +44 7786 525307 Email: louis.bailleul@pgs.com Louis.Bailleul@pgs.com
A Clearer Image | www.pgs.com
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium