Portal Home > Knowledgebase > Articles Database > How to increase open-files-limit to a higher value?
How to increase open-files-limit to a higher value?
Posted by killerlipz, 03-22-2014, 11:27 AM |
Hi,
I am experiencing some issue with Sql.
How to increase open-files-limit to a higher value? or is there other solution to this?
140322 12:47:19 [ERROR] Error in accept: Too many open files
140322 12:51:35 [ERROR] Error in accept: Too many open files
140322 12:55:51 [ERROR] Error in accept: Too many open files
140322 13:00:07 [ERROR] Error in accept: Too many open files
140322 13:04:23 [ERROR] Error in accept: Too many open files
140322 13:08:39 [ERROR] Error in accept: Too many open files
140322 13:12:55 [ERROR] Error in accept: Too many open files
140322 13:17:11 [ERROR] Error in accept: Too many open files
140322 13:21:27 [ERROR] Error in accept: Too many open files
140322 13:25:43 [ERROR] Error in accept: Too many open files
140322 13:29:59 [ERROR] Error in accept: Too many open files
140322 13:34:15 [ERROR] Error in accept: Too many open files
140322 13:38:31 [ERROR] Error in accept: Too many open files
140322 13:42:47 [ERROR] Error in accept: Too many open files
|
Posted by EthernetServers, 03-22-2014, 11:33 AM |
You need to modify /etc/my.cnf via SSH.
E.g:
|
Posted by George_Fusioned, 03-22-2014, 12:11 PM |
Note that you cannot increase the MySQL open_files_limit to a number higher than your ulimit "open files" limit.
To see your current setting type:
In order to increase the limit, open /etc/security/limits.conf and at the bottom of the file enter:
or if you only want to specify a higher ulimit for a specific user, ie. mysql, enter this:
Also repeat for /etc/security/limits.d/90-nproc.conf
Reboot your server for the new limits to apply, or type
to temporarily set the open files limit.
|
Add to Favourites Print this Article
Also Read