InterServed

Well-Known Member
Jul 10, 2007
268
14
68
cPanel Access Level
DataCenter Provider
Up Please :s
Hi,

At first look it seems that you are reaching the open files limit. You will need to increase the limit for max open files:

1) add to /etc/my.cnf ([mysqld] section) (replace 65K with desired maximum open files limit)
open_files_limit = 65K

2)
echo "mysql soft nofile 65536" >>/etc/security/limits.conf
echo "mysql hard nofile 65536" >>/etc/security/limits.conf

3) Stop and restart your mysql service.

The examples i provided should allow mysql service to accept a maximum of 65K open files. Replace/edit to reflect your environment if needed. Note that I'm not responsible for possible issues , use at your own risk.
 

InterServed

Well-Known Member
Jul 10, 2007
268
14
68
cPanel Access Level
DataCenter Provider
I don't understand this lines.....
You can just copy paste them and they should work. It will ensure that your open files limits will be applied at OS level. You could also manually edit the file /etc/security/limits.conf with your favorite editor. Example with nano:

nano /etc/security/limits.conf (you will see examples on how to configure that file) , at the end of the file you can add the configuration i provided:

Code:
mysql soft nofile 65536
mysql hard nofile 65536
or
Code:
* soft nofile 65536
* hard nofile 65536
You can also check what's your mysql open files limit and how many open files there are:
Code:
mysql -e "show status like '%open_files%';" && mysql -e "show variables like '%open_files_limit%';"
 
Last edited: