On Sat, 10 Sep 2005 13:15:57 -0500, Dan Nelson <[EMAIL PROTECTED]> Replied to: Re: Restarting MySQL from CRON With these words of wisdom:
> In the last episode (Sep 10), Gerard Seibert said: > > On Saturday, September 10, 2005 12:27:02 PM Dan Nelson <[EMAIL PROTECTED]> > > wrote: > > > In the last episode (Sep 10), Gerard Seibert said: > > > > From time to time, I have found that MySQL has ceased to run. I > > > > have a mailing program that requires that MySQL be running in > > > > order for it to operate. > > > > > > > > Since I cannot seem to track down why it occasionally stops > > > > functioning, and since the program that depends on it is started > > > > via CRON, would it be advisable to put an entry into the CRON > > > > that would restart MYSQL prior to the other program running. > > > > > > > > I was thinking of using this: > > > > > > > > 0 0 * * * /usr/local/etc/rc.d/mysql-server.sh restart > > > > > > > > Would that work, or is there a better way? > > > > > > "start" is better than "restart", since that won't cause an > > > existing mysqld to exit. But the startup script runs a script > > > called mysqld_safe, which automatically restarts mysqld if it > > > crashes anyway. You might want to check your mysql .err log; maybe > > > someone with the SHUTDOWN privilege is doing a clean shutdown. > > > > It definitely does not restart automatically. In addition, I am the > > only user with root access. I doubt that anyone is shutting it down, > > even by mistake. > > > > Where do I find this mysql error file? I cannot seem to locate it. > > /var/db/mysql/*.err > > If you see "Normal Shutdown"/"Shutdown complete"/"mysqld ended", that's > a clean shutdown initiated by either a client connection or a signal > (SIGTERM for example). Crashes should have a "mysqld got signal ##", a > bunch of debugging info, and a "mysqld restarted" line. You're > obviously not seeing that last line :) > > -- > Dan Nelson > [EMAIL PROTECTED] ********** REPLY SEPARATOR ********** On 9/10/2005 3:17:03 PM Gerard Seibert Replied: Thanks, I will look into that. _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
