• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 118742, created on Nov 19, 2013, last review on May 11, 2014

  • Applies to:
  • Operations Automation

Symptoms

MySQL database related error messages appear on websites from time to time. Example of the error message:

Can't open file: './db123456_dbname/table001.frm' (errno: 24)

Cause

Limit on number of open files was reached on the MySQL server where the customer's database in question is hosted.

Resolution

Increase the number of open files on the MySQL server where the customer's database in question is hosted:

  1. Log in to the MySQL server where the database is hosted

  2. Find the current value of the open_files_limit parameter (the default value is 1024):

    mysql> SHOW VARIABLES LIKE 'open_files_limit';
    +------------------+-------+
    | Variable_name    | Value |
    +------------------+-------+
    | open_files_limit | 1024  |
    +------------------+-------+
    1 row in set (0.00 sec)
    
  3. Open the /etc/my.cnf file and check if the open_files_limit is defined there. If not, then add the line 'open_files_limit = 10000' to the configuration file (you can use some greater value if 10000 is not enough).

  4. Restart MySQL server:

    # /etc/init.d/mysql restart
    
  5. Check if database errors still occur. If they do, try to increase the open_files_limit again.

Search Words

errno: 24

MySQL

Can't open file:

database error message

open_files_limit

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF