NDO only processing some hosts

[Herb J.]

Unless you wish to somehow modify the source code to ignore certain 
hosts (a very risky proposition unless you are good at C), I'd recommend 
against trying to limit the number of hosts that NDO puts in the 
database. Also, having that many services in NDO shouldn't be an issue 
with the hardware you are running (we have almost 7 times as many hosts 
and services in our Nagios installation and NDO doesn't take any time to 
save the data).

There are a number of database optimizations that can be done to the 
MySQL database tables. For starters, make sure all of your tables are 
using InnoDB instead of MyISAM. Secondly, you may wish to lower the 
amount of time that NDO saves some of the various metrics (e.g., service 
check data) because smaller tables are easier to prune old data from. 
And depending on the data you need exported, you may also wish to modify 
the "data_processing_options directive in the NDO config file. Depending 
on how you extract the data from the NDO database, you may need to add 
an extra table index here and there to speed things up.



On 07/14/2010 09:47 AM, Greg Pangrazio wrote:
> Is there a way to limit which hosts get put into the NDO database?  My
> install is getting a bit big and NDO is taking up too much of the CPU
> and making the system sluggish.  If i turn of NDO it works fine.
>
> I use ndo for some custom pages for groups that do not have access to
> nagios and only need to check like 80 services and 40 hosts for those
> pages and the other 800 hosts and 3000 services don't need to be in
> the database.
>
> Maybe I am missing some NDO optimizations too?
>
> The hardware is a dual quad core Xeon 2.5Ghz with 56GB ram so I should
> not be having any problems.
>
> Greg Pangrazio
> pangrazi at gmail.com
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>    


------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null