Greg Pangrazio wrote: > 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. >
Check on indexes for the MySQL schema. there is a -mod sql script next to the normal db schema definition. > Should I go back to the defaults there? > No it's just fine. The defaults are set to high imho, I patched that in IDOUtils too. > Here is the SQL > +------+ > | CNT | > +------+ > | 3232 | > +------+ > > Really I only need service and host status nothing else is of use to me. > Ok, so basically you need to sum up all needed values e.g. containing 'status'. > Does that mean i want the service status data and/or the service check > data. I assume that the host should match. > checks are considered historical. kind regards, Michael > 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 > > -- 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