[Bug 620441] [NEW] MySQL upstart stop job does not cleanly shutdown mysql

2010-08-19 Thread Folke Lemaitre
Public bug reported: Release: Ubuntu 10.04 LTS Package Version: 5.1.41-3ubuntu12.6 Stopping a MySQL server can take some time, especially on a busy database. If mysqld gets killed while having open connections, then after the next start you will likely have a lot of tables corrupted. The new

[Bug 620441] Re: MySQL upstart stop job does not cleanly shutdown mysql

2010-08-19 Thread Folke Lemaitre
Actually the SIGKILL is really always a no go unless a sysadmin decides to do this manually. An upstart script should never do this automatically (not even as a feature ;-) ) I can guarantee that in more than 90% of the cases after a SIGKILL you will have corrupted tables. With the default config