0

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

Improve this question
1
  • 1
    Can you give a bit more data about the problem? Logs and system setup would be helpful?
    – The Unix Janitor
    Mar 18, 2010 at 21:46

1 Answer 1

Reset to default
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.

How do I set my.cnf in Mysql so that there are no limits to connections?

Improve this answer
1
  • +1 because you're wearing a bow tie in your gravatar (and because it's a good answer)
    – Mark Henderson
    Mar 19, 2010 at 2:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .