MySQL Stability

Neil Wilson neilw at
Thu May 28 16:22:36 IST 2009

Hi guys,

There is probably an easy answer to this question, but I've searched 
around on google and can't find much about it.

I'm running Centos 5.2 with mysql-5.0.45-7.el5

Every few days my MySQL seems to die and in the logs I'm seeing the 
following errors.

090528 14:05:37 [ERROR] /usr/libexec/mysqld: Sort aborted
090528 14:07:56 [ERROR] Error in accept: Too many open files
090528 14:11:52 [ERROR] /usr/libexec/mysqld: Sort aborted
090528 14:12:13 [ERROR] Error in accept: Too many open files
090528 14:12:54 [ERROR] /usr/libexec/mysqld: Sort aborted
090528 14:14:26 [ERROR] /usr/libexec/mysqld: Sort aborted
090528 14:18:29 [Note] /usr/libexec/mysqld: Normal shutdown

Then I stop it used the init script and it shutsdown properly.

Then I start it and the problem is gone for the next few days.

The box is processing quite a few mails daily, but I don't think it's 

Processed:    10,277    409.3Mb
Clean:    3,371    32.8%
Spam:    551    5.4%
High Scoring Spam:    6,355    61.8%

My maillog.MYD is 3.4Gigs, is this too large?

Sorry I realise this should probably be sent to a MySQL mailing list, 
but I'm sure people must have some huge MySQL DB's with some of their 
own MailScanner implementations I just want to make sure that we have 
nothing exceptional.

Thanks, any tips will help.



This email and all contents are subject to the following disclaimer:

More information about the MailScanner mailing list