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 <bcantwell@stripped>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=1
>
>
