Very slow startup of Nagios when using NDO

[Caio Peres Sabo]

I have a Nagios-3.0 server with ndo 1.4b7.

My Nagios-3.0 server has 14.300 passive checks.
One statistcs for startup:

- With NDO (~20 minutes):
Begin Start time: Wed Mar 19 17:29:58 BRT 2008
End Start time: Wed Mar 19 17:47:18 BRT 2008

- Without NDO (~10 seconds):
Begin Start time: Wed Mar 19 17:52:12 BRT 2008
End Start time: Wed Mar 19 17:52:23 BRT 2008

With configuration equals into Nagios-2.0 with NDO-1.4b4, startup time is ~4 minutes
Why doesn't Nagios3 scale with NDOb7?

Thanks,
Caio Sabo

-----Original Message-----
From: nagios-users-bounces at lists.sourceforge.net [mailto:nagios-users-bounces at lists.sourceforge.net] On Behalf Of Jim Avery
Sent: quarta-feira, 19 de março de 2008 13:31
To: nagios-users at lists.sourceforge.net
Subject: Re: [Nagios-users] Very slow startup of Nagios when using NDO

On 27/02/2008, Masopust, Christian <christian.masopust at siemens.com> wrote:
> my Nagios server's startup with activated NDO is very slow (appr. 2-3 
> minutes)!
>
> anyone else seeing this behaviour? possibility to speed it up (besides 
> deactivating NDO :-))

Yes.  In earlier versions I think there was a problem with a wrong/missing index on at least one of the tables.  When the ndo daemon starts, it attempts to delete old records from the table and this delete takes ages.  If you monitor your sql database while Nagios is starting, you can probably see the relevant sql running (I used phpMyAdmin for this).  I got around the problem by configuring ndo only to store a tiny amount of information like so (in ndo2db.cfg).

# Keep timed events for 24 hours
max_timedevents_age=1440

# Keep system commands for 1 week
max_systemcommands_age=10080

# Keep service checks for 1 days
max_servicechecks_age=1440

# Keep host checks for 1 week
max_hostchecks_age=10080

# Keep event handlers for 31 days
max_eventhandlers_age=44640


I've also found it doesn't seem to matter (to me, your experience may be different) if I terminate the offending SQL session in MySQL to allow ndo to start more quickly.  Typically I only resort to doing this if I've had ndo disabled for a while then start it up - it then has more deletions than usual to wade through.

As Patrick said, I think the index is fixed in later versions of ndo.
If you're stuck with an earlier version I guess it should be fairly easy to identify where an index would help and add one yourself.  I'm sorry I can't remember precisely which the problemmatic table was.

hth,

Jim

--
Web Admin for Corsham Diary http://corshamdiary.org.uk

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
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


AVISO: A informação contida neste e-mail, bem como em qualquer de seus anexos, é CONFIDENCIAL e destinada ao uso exclusivo do(s) destinatário(s) acima referido(s), podendo conter informações sigilosas e/ou legalmente protegidas. Caso você não seja o destinatário desta mensagem, informamos que qualquer divulgação, distribuição ou cópia deste e-mail e/ou de qualquer de seus anexos é absolutamente proibida. Solicitamos que o remetente seja comunicado imediatamente, respondendo esta mensagem, e que o original desta mensagem e de seus anexos, bem como toda e qualquer cópia e/ou impressão realizada a partir destes, sejam permanentemente apagados e/ou destruídos. Informações adicionais sobre nossa empresa podem ser obtidas no site http://sobre.uol.com.br/.

NOTICE: The information contained in this e-mail and any attachments thereto is CONFIDENTIAL and is intended only for use by the recipient named herein and may contain legally privileged and/or secret information. If you are not the e-mail´s intended recipient, you are hereby notified that any dissemination, distribution or copy of this e-mail, and/or any attachments thereto, is strictly prohibited. Please immediately notify the sender replying to the above mentioned e-mail address, and permanently delete and/or destroy the original and any copy of this e-mail and/or its attachments, as well as any printout thereof. Additional information about our company may be obtained through the site http://www.uol.com.br/ir/.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
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