From: Johan De Meersman Date: October 27 2009 5:35pm Subject: Re: How can I know if Mysql Crashed or stopped gracefully List-Archive: http://lists.mysql.com/mysql/219159 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6d99f20b83dc50476ee1b21 --0016e6d99f20b83dc50476ee1b21 Content-Type: text/plain; charset=ISO-8859-1 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 recovery procedure at startup. On Tue, Oct 27, 2009 at 3:51 PM, Bryan Cantwell wrote: > 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 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 to touch a file that > I look for on restart, but if the stop is never executed on reboot/shutdown, > then I have a problem. > > Thanks for the help, > Bryancan > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@stripped > > --0016e6d99f20b83dc50476ee1b21--