error while running a stored procedure in mysql

Question

Hey i am Getting this error

Out of resources when opening file '#sql_d1c_152.MYD' (Errcode: 24)

in mysql when running a stored procedure

possible duplicate of [Too many open files error on Ubuntu 8.04](http://stackoverflow.com/questions/502545/too-many-open-files-error-on-ubuntu-8-04) — Prahalad Gaggar, Jul 24 '13 at 06:13

score 1 · Accepted Answer · edited Apr 13 '17 at 12:42

1

There is a limit on the number of files you can open simultaneously (1024 I think). You may want to increase the open_files_limit in your MySQL configuration file.

More here: MySQL: Errcode: 24 and here MySQL Bugs: Errcode 24

Some more Information about ideal open_files_limit size: mysql: How do you determine the ideal 'open_files_limit' setting value?

edited Apr 13 '17 at 12:42

Community

1
1

answered Jul 24 '13 at 06:17

Joshua Kissoon

3,269
6
32
58

error while running a stored procedure in mysql

1 Answers1