MYSQL Shutdown

beaudoin_p · Post by **beaudoin_p** » Tue Apr 11, 2006 3:06 pm

Gents,

MYSQL does not react well to a system crash (this being VMS, only upon power failure) but also a normal systems shutdown. I then discovered the mechanism in MYSQLADMIN and instructed the server to SHUTDOWN (yes - 2x as it advises!). I would have thought shutting the server down twice would be enough, but not so! It still corrupted (at least) 2 of 8 or so tables. Now, I will try to issue a series of FLUSH commands before shuting down to see it I can get a clean exit but it occurs to me this is getting a bit silly - surely we do not need to issue anything up to 10 DCL commands to make this die gracefully?
Can somebody educate me on MYSQL shutdown theory?

Many thanks

Paul

Post by **issinoho** » Tue Apr 11, 2006 5:25 pm

Hmmm, I've never had this happen - data corruption, that is. I don't even bother with a syshutdwn.com entry when I reboot.

Anyone else?

Cluster-Karl · Post by **Cluster-Karl** » Thu Apr 13, 2006 5:05 am

$ Set Noon
$ MYSQLADMIN -u 'MyUsername' -p'MyPassword' "SHUTDOWN"
$ wait 00:00:02
$ MYSQLADMIN -u 'MyUsername' -p'MyPassword' "SHUTDOWN"
$ wait 00:00:02
$ MYSQLADMIN -u 'MyUsername' -p'MyPassword' "SHUTDOWN"
$!

This is the sequence we use here ( 3 times seem to work) and we never got a corrupted databse till now.

beaudoin_p · Post by **beaudoin_p** » Mon Apr 24, 2006 9:41 am

Kalle,

Thanks for the advice - it seems to work fine. Still - a bit non-intiative - shut it down 3 times to get it to actually shutdown seems a bit OTT. Nonetheless, it works, is simple and seems reliable - no complaints.

Regards

Paul