NDO Troubles

[seb]

> In order to resolve it, I stop Nagios, stop NDO, restart mysql, drop the
> Nagios database, recreate the Nagios database, start Nagios and start
> NDO.
>
> Once done everything works again. If I don't restart mysql I cannot drop
> the Nagios database within the mysql client and sometimes I need to
> expressly kill (-9) both Nagios and Mysql.

quite an extreme way of terminating mysql :)

Did you try to issue an sql command such as "show full processlist" before
sniping mysqld ?? My nagios database already grew that big, and it was
just sluggish... After allowing innodb to use an insane amount of ram,
it was great :)

-- 
seb

-------------------------------------------------------------------------
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