Suddenly when tried to connect with mysql client, started appearing /usr/sbin/mysqld: Can't open file: xxx.frm (errno: 24). Tried to restart the mysql service but failing to restart properly and can't get it on its feet.
Found below solution which works like a charm !!!
mahen@laptop# vim /etc/mysql/my.cnf
Found below solution which works like a charm !!!
mahen@laptop# vim /etc/mysql/my.cnf
[mysqld]
innodb_file_per_table=1
local-infile=0
open_files_limit=9978 Save the file and restart mysql service by giving following command
mahen@laptop# /etc/init.d/mysql start Thus mysql starts without any errors. :) OS : Ubuntu 14.04 LTSMySQL server : 5.5.37-0ubuntu0.14.04.1
Mahen i think it doesn't matter open_files_limit=9978 if you OS Lable default open files limit is 1024.
ReplyDeleteis there any calculation based on the number of tables and tables size or number of connection?
Please let me know if you have any idea?