[ERROR] /usr/libexec/mysqld: Can't open file: '.s.frm' (errno: 24)

130522  1:45:20 [ERROR] /usr/libexec/mysqld: Can't open file: './alamise/alamise_categories.frm' (errno: 24)

 -----------------------------------------------------------------

ps -ef|grep mysql

查看 pid

pid 32150

 ---------------------------------------------------------------------

cat /proc/32150/limits |grep files

查看pid最大limite

 -------------------------------------------------

lsof -p 32150 |wc -l

查看已经打开的数量

lsof | grep mysqld

查看列表

-----------------------------------------------------------

查看 mysql值

mysql -uUser -pPASS

show global variables like "%open_files_limit%";

-------------------------------------

修复表

mysqlcheck -A -o -r -p

password

----------------------------------------

更改

/etc/my.cnf

[mysqld]

open_files_limit = 100000