Solved

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

Posted on 2013-11-25
8
944 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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 35

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Fine Tune your automatic Updates for Ubuntu / Debian
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
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.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

730 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