how can we prevent this from happening? it generally causes down time of about 30 minutes, which is extremely disruptive for service...
- 1Can you give a bit more data about the problem? Logs and system setup would be helpful?The Unix Janitor– The Unix Janitor2010-03-18 21:46:03 +00:00Commented Mar 18, 2010 at 21:46
Add a comment |
1 Answer
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?
- +1 because you're wearing a bow tie in your gravatar (and because it's a good answer)Mark Henderson– Mark Henderson2010-03-19 02:08:46 +00:00Commented Mar 19, 2010 at 2:08