Mysql Crashing

[neox_blueline]

Im currently running php, and mysql on windows xp, with apache. Mysql seems to crash every so-often, just wondering if there is a way to set it so that it will re-start when it crashes.

(Im using mysql as a windows xp service)

Thanks,
Danny.

[maybl8r03]

Haven't had MySQL crash on me yet (running about 20 MySQL servers on both W2K and WXP) - any ideas why it is crashing? Is it due to load or db size? Have you tried any administrative cleanup (optimize, check etc).

A possible solution to recover from a service crash is to configure it's "recovery" behaviour in the service property (under Control-Panel/Administrative-Tools/Services/MySQL/Properties/Recovery).

There are options for First, Second and Subsequent Failures and possible behaviours are:

1. Take No Action (Default)
2. Restart Service
3. Run a Program
4. Restart Computer

Hope it helps