MySQL keeps restarting due to running out of memory

Question

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

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

score 1 · Answer 1 · edited Apr 13 '17 at 12:14

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?

edited Apr 13 '17 at 12:14

Community

1

answered Mar 19 '10 at 01:53

Warner

23,440
2
57
69

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

MySQL keeps restarting due to running out of memory

1 Answers1

Linked