[ubuntu-us-mi] How to shut down MySQL on Ubuntu Lucid 10.04?

[mike]

Maybe this can help.
http://upstart.ubuntu.com/faq.html#reload
	
On Thu, 2010-12-16 at 12:41 -0500, Robert Citek wrote:
> On Thu, Dec 16, 2010 at 12:32 PM, Craig Maloney <craig at decafbad.net> wrote:
> > On Thu, 2010-12-16 at 12:15 -0500, Robert Citek wrote:
> >> On Thu, Dec 16, 2010 at 11:37 AM, Craig Maloney <craig at decafbad.net> wrote:
> >> > On Thu, 2010-12-16 at 11:26 -0500, Robert Citek wrote:
> >> >> How does one gracefully shut down MySQL on Ubuntu Lucid 10.04?
> >> >>
> >> >
> >> > Best way is to use the service command:
> >> >
> >> > sudo service mysql stop
> >>
> >> That's the problem.  The "best" way corrupts the tables.  Even setting
> >> the kill timeout to 300 doesn't change the default behaviour of
> >> sending a KILL signal after 5 seconds:
> >
> > If you're having problems with InnoDB corrupting tables, then your
> > problem isn't with the start / stop scripts... something isn't getting
> > shut down properly on that machine,
> 
> "MySQL upstart stop job does not cleanly shutdown mysql "
> 
> https://bugs.launchpad.net/ubuntu/maverick/+source/mysql-dfsg-5.1/+bug/620441
> 
> > Good luck. Sounds like a mess. :)
> 
> Indeed.  It's three issues rolled into one:
> 
> 1) mysqladmin shuts down cleanly but upstart starts mysql up again
> because of the respawn command
> 2) upstart's mysql script has a default of 5 seconds, which is too
> short, resulting in upstart killing mysqld and corrupting tables
> 3) upstarts doesn't reread changes to the mysql script, including
> changes to the respawn option and kill timeout.
> 
> It's making a few of us here lose a bit of faith in upstart.
> 
> Regards,
> - Robert
>