NDO only processing some hosts
Michael Friedrich
michael.friedrich at univie.ac.at
Thu Jul 15 17:30:27 CEST 2010
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
> pangrazi at gmail.com
>
>
> On Thu, Jul 15, 2010 at 9:37 AM, Michael Friedrich
> <michael.friedrich at 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
>>> pangrazi at gmail.com
>>>
>>>
>>>
>>>
>>> On Thu, Jul 15, 2010 at 6:42 AM, Michael Friedrich
>>> <michael.friedrich at 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.friedrich at 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 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
>>>
>>>
>>>
>>
>> --
>> DI (FH) Michael Friedrich
>> michael.friedrich at 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 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
>
>
--
DI (FH) Michael Friedrich
michael.friedrich at 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 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
More information about the Users
mailing list