Out of resources when opening file '/????????????.MYD' (Errcode: 24) 解决
MYSQL出现此类错误是因为打开的文件数超过了my.cnf的--open-files-limit。open-files-limit选项无法在mysql命令行直接修改,必须在my.cnf中设定,最大值是65536。
vi /etc/my.cnf
添加:
open-files-limit = 65536
重启mysql
/etc/init.d/mysql stop
sleep 1
/etc/init.d/mysql start
重新启动以后,发现
mysql> show variables like 'open%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 1024 |
+------------------+-------+
1 row in set (0.00 sec)
修改后
mysql> show variables like 'open%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 65536 |
+------------------+-------+
1 row in set (0.00 sec)