Date: Sat, 10 Sep 2005 11:27:02 -0500 From: Dan Nelson <dnelson@allantgroup.com> To: Gerard Seibert <gerard-seibert@suscom.net> Cc: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: Restarting MySQL from CRON Message-ID: <20050910162702.GJ84582@dan.emsphone.com> In-Reply-To: <Pine.WNT.4.63.0509101204160.2920@Treneq.frvorepbz.arg> References: <Pine.WNT.4.63.0509101204160.2920@Treneq.frvorepbz.arg>
next in thread | previous in thread | raw e-mail | index | archive | help
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. -- Dan Nelson dnelson@allantgroup.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050910162702.GJ84582>