Monday 11 March 2013

[ERROR] Error in accept: Too many open files


--open-files-limit=count

Changes the number of file descriptors available to mysqld. You should try increasing the value of this option if mysqld gives you the error Too many open files. mysqld uses the option value to reserve descriptors with setrlimit().
If the requested number of file descriptors cannot be allocated, mysqld writes a warning to the error log.

mysqld may attempt to allocate more than the requested number of descriptors (if they are available), using the values of max_connections and table_open_cache to estimate whether more descriptors will be needed.


Action Plan:--

1) Add this to your my.cnf file:-
[mysqld]
open-files-limit = 12000

2) Restart mysqld


 

No comments:

Post a Comment