NDO update delay

[Rodney Ramos]

Hi, Hendrik. Thank you again.

> Need more information on this.
> Nagios and DB on the same host?

Yes.

> Host stressed up?
Not so much. It stays more stressed when I start the event broker.

> I would suggest to first backup or mirror your database, apply the
> mysql-mods-VERSION.sql file, it should set up some finer indizies, test
> your app and decide to fall back to your old scheme or keep the new one
> (with more indizies).

I didn´t find "mysql-mods-1.4b7.sql" on the "ndoutils-1.4b7" directory
installation. On the db directory there is just an "installdb" script and a
"mysql.sql." file.
Thanks,
Rodney.

On Fri, Mar 27, 2009 at 6:05 PM, Hendrik Baecker <andurin at process-zero.de>wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>
> Rodney Ramos schrieb:
> > Hi, Hendrik. Thanks for your answer.
> >
> >> Guess what - your nagios isn't monitoring anything in that time... ;(
> >
> > I didn´t understand. I can see the "last check" date updated correctly
> > on Nagios Web Interface each 5 minutes. On the other hand, the field on
> > the MySQL is update, but with a 30 minutes of delay, or more.
> >
> I'm sorry - I thought of the wrong blocking thing.
> Sorry for the confusion.
>
> Need more information on this.
> Nagios and DB on the same host?
> Host stressed up?
>
> >> Did you set all those indizies from "db/mysql-mods-1.4b7.sql" ?
> >
> > I´ve created NDO tables as told in the manual, running "db/installdb"
> > script.
> >
> I would suggest to first backup or mirror your database, apply the
> mysql-mods-VERSION.sql file, it should set up some finer indizies, test
> your app and decide to fall back to your old scheme or keep the new one
> (with more indizies).
>
> Think about the three magic words in IT: BACKUP, BACKUP, BACKUP
> on the other side: Never touch a running system, neverever on friday ;)
>
> Regards,
> Hendrik
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAknNP5cACgkQlI0PwfxLQjn3eACZAQsHkKiPEylrSLZFCBqO9Gho
> 3GQAnjaHQy+ok9gAhFIM6Imy8cDhqv4K
> =Zp1l
>  -----END PGP SIGNATURE-----
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20090330/ef9497fd/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel