Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

how can we prevent this from happening? it generally causes down time of about 30 minutes, which is extremely disruptive for service...

share|improve this question

migrated from Mar 18 '10 at 21:43

This question came from our site for professional and enthusiast programmers.

Can you give a bit more data about the problem? Logs and system setup would be helpful? – The Unix Janitor Mar 18 '10 at 21:46

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.

share|improve this answer
+1 because you're wearing a bow tie in your gravatar (and because it's a good answer) – Mark Henderson Mar 19 '10 at 2:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.