[MySQL FAQ]系列 -- Too many open files

.....
070813 13:10:17 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: './yejr/access.frm' (errno: 24)
070813 13:10:17 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: './yejr/accesslog.frm' (errno: 24)
......
070813 13:10:17 [ERROR] Error in accept: Too many open files
....

[root@yejr]# /usr/local/mysql/bin/perror 24
OS error code  24:  Too many open files

[root@yejr]# sysctl -w fs.file-max=43621
[root@yejr]# sysctl -a | grep fs.file-max
fs.file-max = 43621

[root@yejr]# sysctl -w kern.maxfiles=123280
[root@yejr]# sysctl -a | grep kern.maxfiles
kern.maxfiles = 123280

open_files_limit = 4096 
#根据自己的情况适当调整,系统默认值是 
# max_connections*5 或 max_connections + table_cache*2