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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Avery
Sent: quarta-feira, 19 de março de 2008 13:31
To: nagios-users@lists.sourceforge.net
Subject: Re: [Nagios-users] Very slow startup of Nagios when using NDO
On 27/02/2008, Masopust, Christian [EMAIL PROTECTED] 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/vse012070mrt/direct/01/
___
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
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/vse012070mrt/direct/01/
___
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
