• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1022
  • Last Modified:

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

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
Nathan Riley
Asked:
Nathan Riley
3 Solutions
 
Nathan RileyFounderAuthor Commented:
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
 
Loganathan NatarajanLAMP DeveloperCommented:
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
 
Nathan RileyFounderAuthor Commented:
Your link is for windows I believe. My server is running Linux.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Nathan RileyFounderAuthor Commented:
No one?
0
 
Daniel McAllisterPresident, IT4SOHO, LLCCommented:
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
 
Seth SimmonsSr. Systems AdministratorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now