I don't really care about historical data so i was reducing those times to get data out of the DB faster and improve startup times.
Should I go back to the defaults there? Here is the SQL +------+ | CNT | +------+ | 3232 | +------+ Really I only need service and host status nothing else is of use to me. Does that mean i want the service status data and/or the service check data. I assume that the host should match. Greg Pangrazio pangr...@gmail.com On Thu, Jul 15, 2010 at 9:37 AM, Michael Friedrich <michael.friedr...@univie.ac.at> wrote: > Hi, > > Greg Pangrazio wrote: >> max_timedevents_age=60 >> > If you remove that from data_processing_options, it won't be used in the > future. > >> max_systemcommands_age=90 >> max_servicechecks_age=90 >> max_hostchecks_age=90 >> max_eventhandlers_age=1440 >> > > Quite low values, could be that the cleanup interferes with the inserts > (it's cyclic every 60 seconds), but that's just a minor thought. > > Can you show me a > > SQL> SELECT COUNT(*) AS CNT FROM nagios_objects; > > and the summary count of your host and services for futher recommendations. > >> data_processing_options=-1 >> > > Check on that. Do you really need all data or is it just for pulling > status data? > You might wanna check this nifty calculator too > http://labs.consol.de/lang/en/nagios/ndo-data-processing-options/ > > The first thing you won't ever need are the timed events. Icinga > IDOUtils sample configs have been patched in order to prevent timed > event data inserts by default. > > 182 # The default setting will remove the TIMED_EVENT_DATA (67108863 - 2) > 183 > 184 data_processing_options=67108861 > > If you consider far less than that, you might want to check the proposed > settings for NagVis (found somewhere at nagios-portal.org) > > 186 # If you are planning to use NagVis you may want to use the > following setting: > 187 # > 188 #data_processing_options=4061953 > > But, this is the most common recommandation ;-) > > 189 # > 190 # You may have to experiment in your environment and find the best > value yourself! > > >> NDO2DB 1.4b7 >> > > good. read the other thread about newer versions if interested. > > Kind regards, > Michael > >> >> Thanks, >> Greg Pangrazio >> pangr...@gmail.com >> >> >> >> >> On Thu, Jul 15, 2010 at 6:42 AM, Michael Friedrich >> <michael.friedr...@univie.ac.at> wrote: >> >>> 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? >>>> >>>> >>> egrep -v "^#|^%" ndo2db.cfg >>> egrep -v "^#|^%" ndomod.cfg >>> >>> version? >>> >>> and consider like mentioned setting data processing options, and the >>> data trimming options. >>> >>> >>>> The hardware is a dual quad core Xeon 2.5Ghz with 56GB ram so I should >>>> not be having any problems. >>>> >>>> >>> normally I/O problems if the RDBMS is on the same host. >>> >>> Kind regards, >>> Michael >>> >>> >>> >>> -- >>> DI (FH) Michael Friedrich >>> michael.friedr...@univie.ac.at >>> Tel: +43 1 4277 14359 >>> >>> Vienna University Computer Center >>> Universitaetsstrasse 7 A-1010 Vienna, Austria >>> >>> >>> ------------------------------------------------------------------------------ >>> 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 >> >> > > > -- > DI (FH) Michael Friedrich > michael.friedr...@univie.ac.at > Tel: +43 1 4277 14359 > > Vienna University Computer Center > Universitaetsstrasse 7 A-1010 Vienna, Austria > > > ------------------------------------------------------------------------------ > 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