neilw at dcdata.co.za
Thu May 28 16:22:36 IST 2009
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
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
Thanks, any tips will help.
This email and all contents are subject to the following disclaimer:
More information about the MailScanner