how can we prevent this from happening? it generally causes down time of about 30 minutes, which is extremely disruptive for service...
migrated from stackoverflow.com Mar 18 '10 at 21:43
This question came from our site for professional and enthusiast programmers.
MySQL tag, so I'm guessing MySQL. I've had that FUBAR an InnoDB database before.
Sounds like you do not have your configuration optimized at all. Tuning is going to be specific to your database engine. I provided some general recommendations in the post linked below, which would apply to you as well.