Re: How can I know if Mysql Crashed or stopped gracefully

2009-10-27 Thread Todd Lyons
On Tue, Oct 27, 2009 at 7:51 AM, Bryan Cantwell wrote: > I notice that issuing a reboot or shutdown -r now command, (in Linux) that > the 'service mysql stop'  is never run... it just seems to catch the sig 15 > and does its own shutdown... > I have scripted in the stop section of my init script t

Re: How can I know if Mysql Crashed or stopped gracefully

2009-10-27 Thread Johan De Meersman
Signal 15 is pretty much equal to a regular shutdown, except that if your shutdown script doesn't run, you may be left with lockfiles, pidfiles and the like. A crash would most likely be visible in the logfile, and even if it isn't (machine loses power), your log should show innodb running a recov

How can I know if Mysql Crashed or stopped gracefully

2009-10-27 Thread Bryan Cantwell
I have an environment where upon boot of a machine I need to know if mysql shutdown nicely or if it crashed. How can I know for sure which was the case so that I can take action if needed? I notice that issuing a reboot or shutdown -r now command, (in Linux) that the 'service mysql stop' is nev