MySQL Stability

[Neil Wilson]

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 
exceptional.

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.

Regards.

Neil.

This email and all contents are subject to the following disclaimer:
http://www.dcdata.co.za/emaildisclaimer.html