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