Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Mar 18 '10 at 21:43

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

1  
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

1 Answer 1

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.

http://serverfault.com/questions/119468/how-do-i-set-my-cnf-in-mysql-so-that-there-are-no-limits-to-connections/119550#119550

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

 
discard

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.