Solved

mysql error: Error: 23 - Out of resources when opening file

Posted on 2013-11-25
8
922 Views
Last Modified: 2013-12-17
My server has a site that's getting a lot of traffic lately and I'm seeing some mysql errors coming up in the IP.Board logs.  It says it's an error with mysql not the software.

Anyone know how to fix the error:
Error: 23 - Out of resources when opening file
0
Comment
Question by:N R
8 Comments
 
LVL 11

Author Comment

by:N R
ID: 39676596
I found some people saying to open:
/etc/security/limits.conf

and add:
mysql soft nofile 24000
mysql hard nofile 32000

Any issues with doing this?
0
 
LVL 36

Accepted Solution

by:
Loganathan Natarajan earned 167 total points
ID: 39676710
Also do this,

Increase the open file limit in the "/etc/mysql/my.cnf"

open_file_limit=3072

Open in new window


Stop / restart the mysql after that.

ref. http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html
0
 
LVL 11

Author Comment

by:N R
ID: 39676719
Your link is for windows I believe. My server is running Linux.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 11

Author Comment

by:N R
ID: 39698233
No one?
0
 
LVL 20

Assisted Solution

by:Daniel McAllister
Daniel McAllister earned 167 total points
ID: 39724030
Gallitin:

While the link provided by logudotcom may have been for Windows, the entry above it (where he suggests open_file_limit=3072 in /etc/mysql/my.cnf) is actually Linux -- albeit, on some Linux systems, my.cnf is in /etc, not in /etc/mysql.

That being said, in addition to there being an open file limit being exceeded, you may also be overstepping your memory bounds... but I would try the open files setting first.

Dan
IT4SOHO
0
 
LVL 34

Assisted Solution

by:Seth Simmons
Seth Simmons earned 166 total points
ID: 39724034
your first comment about modifying limits.conf should fix your issue
try it and see how that works
no harm in making the change
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now