Bookmark and Share
Can't open file (errno: 24)
(Publish Date: 2009-11-3 11:57am, Total Visits: 6736, Today: 1, This Week: 1, This Month: 3)

I go the following errors in a database:

091030 0:23:46 [ERROR] /usr/sbin/mysqld-max: Can't open file: './register/member.frm' (errno: 24)
091030 0:23:46 [ERROR] /usr/sbin/mysqld-max: Can't open file: './register/description.frm' (errno: 24)

This is related to file descriptors.

# perror 24
OS error code  24:  Too many open files

I enlarge the value of open_files_limit by adding a line in my.cnf.

open_files_limit=5000

For open_files_limit, please refer this link:

http://cherry.world.edoors.com/CozM0IXYA-fc

For more explanation about this error, please refer this page:

B.5.2.18. 'File' Not Found and Similar Errors
http://dev.mysql.com/doc/refman/5.0/en/not-enough-file-handles.html