availability reports slow
Posted: Tue Nov 01, 2016 12:44 pm
Moderator Edit: This thread has been split from another - https://support.nagios.com/forum/viewto ... =6&t=35886
In the future, please create a new thread and link to the old one instead of adding on.
I am having a similar issue on my environment (the availability report takes about 5 minutes to generate, which is especially frustrating since what I need to run it for is not the default parameters). I figure I would post here as I don't see what the eventual fix was for the other users experiencing the issue.
Nagios version: 2014 R2.7 ... in process of being upgraded to 5.3.0
Nagios db: not offloaded
Specs: 4 vcpu 8 GB RAM 200GB HD
Availability report contains approx 20-50 hosts for a time period of prior month
In the future, please create a new thread and link to the old one instead of adding on.
I am having a similar issue on my environment (the availability report takes about 5 minutes to generate, which is especially frustrating since what I need to run it for is not the default parameters). I figure I would post here as I don't see what the eventual fix was for the other users experiencing the issue.
Nagios version: 2014 R2.7 ... in process of being upgraded to 5.3.0
Nagios db: not offloaded
Specs: 4 vcpu 8 GB RAM 200GB HD
Availability report contains approx 20-50 hosts for a time period of prior month
Code: Select all
Nagios Stats 4.0.8
Copyright (c) 2003-2008 Ethan Galstad (www.nagios.org)
Last Modified: 08-12-2014
License: GPL
CURRENT STATUS DATA
------------------------------------------------------
Status File: /usr/local/nagios/var/status.dat
Status File Age: 0d 0h 0m 3s
Status File Version: 4.0.8
Program Running Time: 0d 0h 15m 23s
Nagios PID: 579
Total Services: 4531
Services Checked: 4531
Services Scheduled: 4531
Services Actively Checked: 4531
Services Passively Checked: 0
Total Service State Change: 0.000 / 17.500 / 0.054 %
Active Service Latency: 0.000 / 0.141 / 0.001 sec
Active Service Execution Time: 0.001 / 70.007 / 0.805 sec
Active Service State Change: 0.000 / 17.500 / 0.054 %
Active Services Last 1/5/15/60 min: 265 / 3986 / 4171 / 4530
Passive Service Latency: 0.000 / 0.000 / 0.000 sec
Passive Service State Change: 0.000 / 0.000 / 0.000 %
Passive Services Last 1/5/15/60 min: 0 / 0 / 0 / 0
Services Ok/Warn/Unk/Crit: 4404 / 34 / 26 / 67
Services Flapping: 2
Services In Downtime: 58
Total Hosts: 1076
Hosts Checked: 1075
Hosts Scheduled: 1076
Hosts Actively Checked: 1076
Host Passively Checked: 0
Total Host State Change: 0.000 / 8.820 / 0.017 %
Active Host Latency: 0.000 / 0.087 / 0.000 sec
Active Host Execution Time: 0.000 / 10.032 / 0.364 sec
Active Host State Change: 0.000 / 8.820 / 0.017 %
Active Hosts Last 1/5/15/60 min: 641 / 1073 / 1074 / 1074
Passive Host Latency: 0.000 / 0.000 / 0.000 sec
Passive Host State Change: 0.000 / 0.000 / 0.000 %
Passive Hosts Last 1/5/15/60 min: 0 / 0 / 0 / 0
Hosts Up/Down/Unreach: 1061 / 15 / 0
Hosts Flapping: 0
Hosts In Downtime: 5
Active Host Checks Last 1/5/15 min: 713 / 3436 / 10176
Scheduled: 712 / 3410 / 10100
On-demand: 1 / 26 / 76
Parallel: 712 / 3410 / 10100
Serial: 0 / 0 / 0
Cached: 1 / 26 / 76
Passive Host Checks Last 1/5/15 min: 0 / 0 / 0
Active Service Checks Last 1/5/15 min: 298 / 4054 / 12478
Scheduled: 298 / 4054 / 12478
On-demand: 0 / 0 / 0
Cached: 0 / 0 / 0
Passive Service Checks Last 1/5/15 min: 0 / 0 / 0
External Commands Last 1/5/15 min: 0 / 0 / 2
Code: Select all
[coadminsj@cawlkl21 ~]$ ls -l /usr/local/nagios/var/nagios.log
-rw-r--r-- 1 nagios nagios 2742481 Nov 1 13:33 /usr/local/nagios/var/nagios.log
[coadminsj@cawlkl21 ~]$ du -h /usr/local/nagios/var/archives/
135M /usr/local/nagios/var/archives/
[coadminsj@cawlkl21 ~]$ ls /usr/local/nagios/var/archives/|wc -l
6
Code: Select all
top | head -17
top - 13:40:35 up 79 days, 4:50, 1 user, load average: 2.04, 2.53, 2.29
Tasks: 274 total, 1 running, 273 sleeping, 0 stopped, 0 zombie
Cpu(s): 7.8%us, 2.8%sy, 0.0%ni, 88.2%id, 1.0%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 8177336k total, 7208852k used, 968484k free, 405612k buffers
Swap: 16777212k total, 361748k used, 16415464k free, 3613960k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
583 nagios 20 0 10072 996 664 S 1.9 0.0 0:01.31 nagios
585 nagios 20 0 10072 992 668 S 1.9 0.0 0:01.22 nagios
1 root 20 0 21500 1204 976 S 0.0 0.0 0:16.88 init
2 root 20 0 0 0 0 S 0.0 0.0 0:01.52 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 1:48.81 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/u:0H
8 root RT 0 0 0 0 S 0.0 0.0 5:49.32 migration/0
9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
10 root 20 0 0 0 0 S 0.0 0.0 165:17.04