availability reports slow

[rkennedy]

Please look at the post above by @scottwilkerson as this should provide you an answer. We'll need the questions answered as well.

[jonathan.cruz]

I running the report for 24Hrs and is a VM running on a Storage FC with high performance.

Below the outputs.


ls -l /usr/local/nagios/var/nagios.log
-rw-r--r-- 1 nagios nagios 8988357 Feb 18 17:00 /usr/local/nagios/var/nagios.log

du -h /usr/local/nagios/var/archives/
2.9G /usr/local/nagios/var/archives/


ls /usr/local/nagios/var/archives/|wc -l
152

[tgriep]

How many hosts and services is the server monitoring?
What time frame are you selecting for the report?

[jonathan.cruz]

I am try using the last 24hours frame and i have 500 host and 5000 services.

Mys server
16GB RAM
16 cores 2 GHz

[rkennedy]

What is the output of top|head -17?

[jonathan.cruz]

top - 15:06:34 up 4 days, 3:21, 1 user, load average: 5.87, 5.73, 5.62
Tasks: 531 total, 5 running, 525 sleeping, 0 stopped, 1 zombie
Cpu(s): 15.5%us, 2.8%sy, 0.0%ni, 76.9%id, 4.5%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 16326596k total, 8113484k used, 8213112k free, 234984k buffers
Swap: 2064380k total, 0k used, 2064380k free, 5179172k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3114 nagios 20 0 247m 82m 4684 R 88.8 0.5 0:06.49 check_esx3.pl
3430 nagios 20 0 210m 44m 4680 R 88.8 0.3 0:01.24 check_esx3.pl
3499 nagios 20 0 327m 23m 9804 D 88.8 0.1 0:00.50 check_oracle_he
22414 apache 20 0 462m 51m 5704 R 38.8 0.3 0:52.92 httpd
42774 apache 20 0 450m 40m 5928 R 37.0 0.3 9:33.06 httpd
3298 nagios 20 0 189m 23m 4360 S 20.3 0.1 0:00.38 check_esx3.pl
63131 nagios 20 0 53104 4896 1024 S 20.3 0.0 0:32.28 ndo2db
1886 mysql 20 0 8341m 283m 6576 S 18.5 1.8 1252:00 mysqld
3508 nagios 20 0 110m 2964 1688 S 18.5 0.0 0:00.10 snmpwalk
544 nagios 20 0 322m 32m 8272 S 12.9 0.2 0:00.44 php

[rkennedy]

How many CPUs do you have allocated to the machine?

Also, I asked the OP this. Please answer as well -

I don't think this was mentioned previously, can you please clarify - are you offloading your SQL currently?

If so, are you hosting it locally, or remotely?

[jonathan.cruz]

I have 16 cpus for this machine and i run the mysql localy

[rkennedy]

Can you please PM a profile over to me? (Admin -> System Profile -> Download Profile)

I'll take a look and what I can find. At a first glance with what you've provided, it's not in clear view what the issue is.