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 > pangr...@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@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@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