From: Rodney R. <rod...@gm...> - 2009-03-30 13:03:20
|
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 <an...@pr...>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 > Nag...@li... > https://lists.sourceforge.net/lists/listinfo/nagios-devel > |