Problem description

When using an apsaradb RDS for MySQL instance, the following error message is displayed.

Out of resources when opening file './xxx.MYD' (Errcode: 24)

 

Causes

The number of files opened in the apsaradb RDS for MySQL instance exceeds the open_files_limit parameter limit.

 

Solutions

Alibaba Cloud reminds you that:

  • When you perform operations that have risks, such as modifying instance configurations or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
  • Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
  • If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
Expand the range of open_files_limit parameters on the parameter settings page of the RDS console. After modifying these parameters, restart the instance for them to take effect.
open_files_limit

 Note: open_files_limit the default value is 65535, which ranges from 4000 to 65535 in the RDS console.

 

Application scope

  • ApsaraDB RDS for MySQL

 

If the problem persists, you can receive a free consultation in Alibaba Cloud Community or submit a ticket to contact Alibaba Cloud technical support personnel.