Page 1 of 1

auto-restart

Posted: Wed Dec 05, 2007 7:35 am
by WillemGrooters
On my system, MySQL has a tendency of crashing, mostly when flushing buffers. The log states an OS code of 12 - and concludes "not enough core". 12 = 0C = ACCVIO - so what is the problem??? :evil:

This is very annoying - because it often happens when I'm not around. So I created a batchprocedure that scans the system for a process named "MYSQL_SERVER" and if it doens't find one, it will start the database again. This procedure runs every 15 minutes, so if the database crashes, it's up and running - until the next crash - within 15 minutes.

The database crashes will be discussed on the MySQL mailing list - when I can find the address :roll: