17 Jun
2014
17 Jun
'14
4:35 a.m.
Hi Paul
Have no issues like this (using community edition BTW), with about 142 devices polled.
The stuff I already did:
- apparently it was running on a 32bit kernel, move it to a new 64bit
- changed to 4 cores .. no real result
- disabled the unused-polling
It seems that the cpu-usage of mysqld goes really high when logging in to show to startpage with the map ..
when going directly to the device the response-time is "okay" but not great.
When running mysqltuner:
innodb_buffer_pool_size should be greater than 23G ?
How big is your ibdata1 ?
Some optimizations :
innodb_file_per_table=1 innodb_buffer_pool_size=1024M max_connections = 300
And use XFS with option noatime uppon options of FSTAB.
Also use elevator=deadline or elevator=noop (on a VM) is the best way to have more IO than the shitty CFQ ...
Xavier
--
Xavier Beaudouin - Senior Network and System Administrator
Infrastructure and network director
Horizon Software - http://www.hsoftware.com/
13 rue La Fayette - 75009 PARIS - France
Phone: +33 (0)1 4260 9490 Fax: +33 (0)1 44 56 97 01
Why Top posting is bad : http://ck.wikia.com/wiki/TopPosting