February 7th, 2013, 02:28 AM
Join Date: Feb 2013
Time spent in forums: 55 m 40 sec
Reputation Power: 0
[Error]Too many open files
My name is Hoang, I had setup a server database use MySQL version 5.1.37-ndb-7.0.8a-cluster-gpl on Linux(CentOS 5.5).
I config MySQL :
open_file_limit = 2048
on System, i use command : ulimit -n --> 1024
the recent, i see "error 24: Too many open files" in log of mysql and i check number of files open of process mysql used to command
> cd /proc/<id_process_mysql>/fd
> ll | wc -l
>lsoft | wc -l --> result = 2048
I have increased the value of open_files_limit=6000, but then this error still repeat. i don't know fix this error, i hope you can help me!