Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/components/com_k2/models/item.php on line 763

[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

 

 

 

 

 

 

 

Last modified onWednesday, 22 May 2013 11:59

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169
  • Published in MYSQL
  • Read 1481 times

Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478
back to top