<div>
I found some people saying to open:<br />
/etc/security/limits.conf<br />
<br />
and add:<br />
mysql soft nofile 24000<br />
mysql hard nofile 32000<br />
<br />
Any issues with doing this?
</div>


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?

<div>
Your link is for windows I believe. My server is running Linux.
</div>


Your link is for windows I believe. My server is running Linux.

<div>
<div class="content wysiwyg-content">
My server has a site that's getting a lot of traffic lately and I'm seeing some mysql errors coming up in the <a href="http://www.invisionpower.com/apps/board/" rel="ugc">IP.Board</a> logs. &nbsp;It says it's an error with mysql not the software.<br />
<br />
Anyone know how to fix the error:<br />
Error: 23 - Out of resources when opening file
</div>
</div>


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 (http://www.invisionpower.com/apps/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

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.