连接不上数据库
查看日志
090811 9:02:35 [ERROR] /usr/local/mysql/libexec/mysqld: Can't open file: './news_data/E_info.frm' (errno: 24)
090811 9:02:54 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
090811 9:03:36 [ERROR] Error in accept: Too many open files应该是分区过多,打开文件超过linux 1024的限制了!
这个如何解决呢?
查看日志
090811 9:02:35 [ERROR] /usr/local/mysql/libexec/mysqld: Can't open file: './news_data/E_info.frm' (errno: 24)
090811 9:02:54 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
090811 9:03:36 [ERROR] Error in accept: Too many open files应该是分区过多,打开文件超过linux 1024的限制了!
这个如何解决呢?
嗯,问题解决了!
ulimit -n 65536 #设置文件连接数由1024到65536.
my.cnf中添加 open_files_limit = 10000
即可!不过用ulimit 设置可能在机器重启后就失效,我去看看/etc/security这个文件!