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.
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