Availability Report Performance (Avail.cgi )

[abhishek]

Moderator Edit: This thread has been split from another - https://support.nagios.com/forum/viewtopic.php?t=41183
In the future, please create a new thread and link to the old one instead of adding on.

Hi ,
I have also same issue with performance of availability report . when i generate availability report then the avail.cfg process takes 90-100% CPU and the result comes to me after 10-15 minutes. I have approximate 5K Hosts and 32K services . And my system configuration is 32GB RAM with 1TB HDD and 16 core cpu with threading . kindly help me to overcome from this .

[dwhitfield]

32K Services is a lot. I suspect you'll need to do some process off-loading. You should take a look at https://assets.nagios.com/downloads/nag ... ios_XI.pdf

There are simpler "solutions" at https://assets.nagios.com/downloads/nag ... ios-XI.pdf, but whether they actually solve your issue will depend on a variety of factors. I'm guessing that 1TB is not a SSD?

[abhishek]

Hi,
My Database server are on different machine and i am using 6 Mod_gearman worker to handle the services and we are using 1TB SAS hard disk . So kindly suggest me how to over come from this situation .

[dwhitfield]

Can you PM me your profile? Admin > System Config > System Profile (click "Show Profile" in XI 5 onwards). Thanks!

[abhishek]

Hi ,
PFA for my nagios profile.

[abhishek]

Hi,
nagios profile is :
Nagios XI Installation Profile
System:
Nagios XI Version : 5.2.9
appserver1 2.6.32-642.4.2.el6.x86_64 x86_64
CentOS release 6.8 (Final)
Gnome is not installed
Apache Information
PHP Version: 5.3.3
Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Server Name: nagios.spectranet.in
Server Address: 203.122.61.108
Server Port: 80
Date/Time
PHP Timezone: Asia/Kolkata
PHP Time: Tue, 22 Nov 2016 10:53:00 +0530
System Time: Tue, 22 Nov 2016 10:53:00 +0530
Nagios XI Data
License ends in: OUVORN

nagios (pid 127791) is running...
NPCD running (pid 3505).
ndo2db (pid 43763) is running...
CPU Load 15: 2.28
Total Hosts: 4612
Total Services: 23680
Function 'get_base_uri' returns: http://nagios.spectranet.in/nagiosxi/
Function 'get_base_url' returns: http://nagios.spectranet.in/nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: http://nagios.spectranet.in/nagiosxi/in ... rofile.php
Function 'get_backend_url(internal_call=true)' returns: http://localhost/nagiosxi/backend/
Ping Test localhost
Running:

/bin/ping -c 3 localhost 2>&1

PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.012 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.013 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.019 ms

--- localhost ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2000ms
rtt min/avg/max/mdev = 0.012/0.014/0.019/0.005 ms
Test wget To localhost
WGET From URL: http://localhost/nagiosxi/includes/components/ccm/
Running:

/usr/bin/wget http://localhost/nagiosxi/includes/components/ccm/

--2016-11-22 10:53:02-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: "/usr/local/nagiosxi/tmp/ccm_index.tmp"

0K ......... 853M=0s

2016-11-22 10:53:03 (853 MB/s) - "/usr/local/nagiosxi/tmp/ccm_index.tmp" saved [9886]

Network Settings

1: lo: mtu 65536 qdisc noqueue state UNKNOWN

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 scope host lo

inet6 ::1/128 scope host

valid_lft forever preferred_lft forever

2: em1: mtu 1500 qdisc mq state UP qlen 1000

link/ether 18:66:da:5c:c1:85 brd ff:ff:ff:ff:ff:ff

inet 203.122.61.108/29 brd 203.122.61.111 scope global em1

inet6 fe80:daff:fe5c:c185/64 scope link

valid_lft forever preferred_lft forever

3: em2: mtu 1500 qdisc noop state DOWN qlen 1000

link/ether 18:66:da:5c:c1:86 brd ff:ff:ff:ff:ff:ff

4: em3: mtu 1500 qdisc noop state DOWN qlen 1000

link/ether 18:66:da:5c:c1:87 brd ff:ff:ff:ff:ff:ff

5: em4: mtu 1500 qdisc mq state UP qlen 1000

link/ether 18:66:da:5c:c1:88 brd ff:ff:ff:ff:ff:ff

inet 192.168.1.3/24 brd 192.168.1.255 scope global em4

inet6 fe80:daff:fe5c:c188/64 scope link

valid_lft forever preferred_lft forever


203.122.61.104/29 dev em1 proto kernel scope link src 203.122.61.108

192.168.1.0/24 dev em4 proto kernel scope link src 192.168.1.3

169.254.0.0/16 dev em1 scope link metric 1002

169.254.0.0/16 dev em4 scope link metric 1005

default via 203.122.61.105 dev em1

[dwhitfield]

There aren't a ton of performance improvements in 5.3.x, but there are some. I would suggest giving the upgrade a try before we move on. Instructions are at https://assets.nagios.com/downloads/nag ... nstall.pdf

5.3.x now has an offline installer if that would be useful: http://repo.nagios.com/

Please let us know if it does not improve the situation.