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 — Prahalad Gaggar
– Prahalad Gaggar, Commented Jul 24, 2013 at 6:13

Community · Accepted Answer · 2017-04-13 12:42:38Z

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, 2017 at 12:42

CommunityBot

11 silver badge

answered Jul 24, 2013 at 6:17

Joshua Kissoon

3,3296 gold badges34 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error while running a stored procedure in mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related