mysql"Out of resources when opening file"错误怎么解决？

[bdgoog]

多个网站在同一台服务器上，访问其中一个网站的时候，出现如下的错误提示：
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `feokj_shop`.`ecs_sessions` (sesskey, expiry, ip, data) VALUES ('38796f5e5768b6d922cb7ece9ea9b02a', '1370523934', '123.116.229.194', 'a:0:{}') ) [2] => Array ( [error] => Out of resources when opening file '.\feokj_shop\ecs_sessions.MYD' (Errcode: 24) ) [3] => Array ( [errno] => 23 ) )
其它网站可以正常访问。请大家帮帮忙。多谢

[rucypli]

ulimit -a看看是否打开最大文件数设置的太小

[bdgoog]

经常出现这种错误，Can't create/write to file '#sql_d28_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ，服务器没装麦克菲

[rucypli]

引用 2 楼 bdgoog 的回复:

经常出现这种错误，Can't create/write to file '#sql_d28_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ，服务器没装麦克菲

看一下mysql设置的tmpdir路径 是否太小

[bdgoog]

是服务器负载太大了