Monday, August 5, 2013

[ERROR] /usr/sbin/mysqld: Can't open file: (errno: 24)

[ERROR] /usr/sbin/mysqld: Can't open file: (errno: 24)
Upon checking the mysql logs in /var/lib/mysql/HOSTNAME.err, I got error as :

-----------------------------------------------------------------------------
[ERROR] /usr/sbin/mysqld: Can't open file: './database/table.frm' (errno: 24)
-----------------------------------------------------------------------------

errno: 24 simply means that too many files are open for the given process. There is a read-only mysql variable called open_files_limit that will show how many open files are allowed by the mysqld. A lot systems set this to something very low, like 1024. When creating a large number of partitions or tables, MySQL may mysteriously stop working and will generate this eeror.
Add the following parameter in /etc/my.cnf file and restart mysql service.
[mysqld]open_files_limit = 100000

No comments:

Post a Comment