MySQL error: File not found

Tags:
Database
MySQL
Last two days I am getting the same error in MySQL 5.1.23 - 'File' Not Found. It appeared suddenly and I really don`t know the reason of such MySQL behavior. I mean, everything worked fine until the last days. I tried to use a build-in options, such Repair database and check table. These features always helped me if something was wrong, but now they don`t. Also i used MySQLcheck command with exactly the same (null) result. Maybe I need to use another one command or change something in my settings? If anyone explain me what is going on it would be great. I want to understand the problem to prevent such issues in future.


Software/Hardware used:
MySQL 5.1.23
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Such error means
that you haven’t allocated enough file descriptors for the MySQL server. You
can use the perror utility to get a description of what the error number
means, for example:

shell>
perror 23

OS error
code  23: 
File table overflow

shell>
perror 24

OS error
code  24: 
Too many open files

shell>
perror 11

OS error
code  11: 
Resource temporarily unavailable

The problem
here is that mysqld is trying to keep open too many files simultaneously. You
can either tell mysqld not to open so many files at once or increase the number
of file descriptors available to mysqld.

So, first you should get more specific
information about your issue, and then try to fix it. If something goes wrong
or when you have tried all the features, commands and methods, but nothing
works, in this case you need another kind of solution. Even third-party, some
of them can really help. I would recommend you Recovery Toolbox for MySQL  https://mysql.recoverytoolbox.com/

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: