MYSQL out of the resources when opening file './xxx. MYD ' (errcode:24)

Appears out of the resources when opening file './xxx. MYD ' (errcode:24) error is because the number of open files exceeds the--open-files-limit of MY.CNF. The OPEN-FILES-LIMIT option cannot be modified directly on the MySQL command line and must be set in MY.CNF with a maximum value of 65536.

Restart Mysqld,

Mysql> Show variables like ' open% ';

+------------------+-------+

| variable_name | Value |

+------------------+-------+ |

Open_files_limit | 1024 |

+------------------+-------+
If it is found that this variable does not change most likely the number of open files on the server set the value of limits (Ulimit-n view). If it is found to be 1024, the value is also changed to 65536 after MY.CNF is modified to 65536. You will need to log back in to the server and restart the database service to be OK. This value takes the minimum value set by the database and server.

Mysql> Show variables like ' open% ';

+------------------+-------+

| variable_name | Value |

+------------------+-------+

| Open_files_limit | 65536 |

+------------------+-------+