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...

/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 ( SET

PASSWORD 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@SpecificDNSorIp

Variables to adjust:

innodb_buffer_pool_instances(=8)

---

Thanks.

Best regards,

Louis

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

*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