Topic: MySql stops

[zaker]

I'm not sure why, but Mysql daemon stops working on my SME 6.01 box. A mysql restart brings it back, but I need to know why it's dying.

It's used as a mail server, PIII w/512M, ClamAv and Spamassassin.

I do see things like this in the messages log:
Apr 12 00:20:41 io kernel: Out of Memory: Killed process 1392 (httpd).
Apr 12 00:30:05 io kernel: Out of Memory: Killed process 1394 (httpd).
Apr 12 00:36:16 io kernel: Out of Memory: Killed process 1391 (httpd).
Apr 12 00:40:02 io kernel: Out of Memory: Killed process 1393 (httpd).
Apr 12 00:43:02 io kernel: Out of Memory: Killed process 6557 (httpd).
Apr 12 00:50:11 io kernel: Out of Memory: Killed process 1390 (httpd).
Apr 12 00:57:08 io kernel: Out of Memory: Killed process 26173 (httpd).
Apr 12 00:57:22 io kernel: Out of Memory: Killed process 1389 (httpd).
Apr 12 01:00:09 io kernel: Out of Memory: Killed process 1387 (httpd).
Apr 12 01:00:33 io kernel: Out of Memory: Killed process 1388 (httpd).
Apr 12 01:00:53 io kernel: Out of Memory: Killed process 1395 (httpd).
Apr 12 01:01:08 io kernel: Out of Memory: Killed process 1396 (httpd).
Apr 12 01:01:17 io kernel: Out of Memory: Killed process 6553 (httpd).
Apr 12 01:02:14 io kernel: Out of Memory: Killed process 26188 (httpd).
Apr 12 01:02:37 io kernel: Out of Memory: Killed process 26189 (httpd).
Apr 12 01:02:52 io kernel: Out of Memory: Killed process 6558 (httpd).
Apr 12 01:03:03 io kernel: Out of Memory: Killed process 25524 (clamscan).

I already have a crontab to restart mysql in the morning in case it's dead, but it's only a temporary fix.

Any ideas/suggestions??

[mach1_4fun]

Hello,

How many users do you have attached to this server?
I know that Spamassassin and clamd take a lot of memory to run properly. Even with a small number of users.

Initially, it looks to me like you need more RAM. I would grab another 512MB, it can't hurt.

good luck!

[zaker]

There are about 50 users. Nothing major, but it does seem to be Clam/Spamassassin related. If I disable SA it doesn't seem to have a problem, but then I can't handle the SPAM!!!

Adding more RAM was my next step.

thanks
zaker

[mach1_4fun]

Hey Zaker,
50 users, I might try an extra gigabyte if you can, especially if you are going to be growing at all. Its a pretty good investment into stability in my opinion.

I have about 20-30+ simulatenous users at any given time (about 200 total) and I have been really happy since I upped it to 2 gigs (Dual 600 P3 server).

Best of luck!

[raem]

zaker

>.....it does seem to be Clam/Spamassassin related. > If I disable SA it doesn't seem to have a problem, but then I can't handle the SPAM!!!

Have you enabled RBL list blocking, your spam load will reduce dramatically.
Have you enabled pattern matching, your virus load will reduce dramatically.

If you implement the abovementioned your server will have a lot less work to do and may not need more RAM.

There are also a few email & spam tweaks that may also help re concurrent clam, spam & qmail processes.
All the info has been posted to these forums many times. If you can't find it then ask again.