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

[Robert Citek]

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