Solved

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

Posted on 2013-11-25
8
936 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

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

Suggested Solutions

Title # Comments Views Activity
powershell and sql server - alerting 7 77
count download link and run update query 9 55
SQL Query 34 81
SSRS troubles 4 14
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

910 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

22 Experts available now in Live!

Get 1:1 Help Now