错误代码:23打开文件时资源不足 [英] Error Code: 23 Out of resources when opening file

问题描述

在MySQL中执行查询时，出现此错误:

When I execute a query in MySQL, I get this error:

错误代码:23
打开文件'.\ test \ sample_table#P#p364.MYD'时资源不足(错误代码:24-打开的文件太多)

Error Code: 23
Out of resources when opening file '.\test\sample_table#P#p364.MYD' (Errcode: 24 - Too many open files)

MySQL版本详细信息:

MySQL version details:

VERSION                   5.6.21 
version_comment           MySQL Community SERVER (GPL)
version_compile_machine   x86_64
version_compile_os        Win64

如何解决这个问题?

推荐答案

mysql错误:打开文件时资源不足...(错误代码:24)表明已超过允许打开msyql的文件数.

The mysql error: Out of resources when opening file... (Errcode: 24) indicates that the number of files that msyql is permitted to open has been exceeded.

此限制由变量open_files_limit控制.您可以在phpMyAdmin(或MySQL命令行实用程序)中使用以下语句阅读此内容:

This limit is controlled by the variable open_files_limit. You can read this in phpMyAdmin (or the MySQL command line utility) with the statement:

SHOW VARIABLES LIKE 'open%'

要将此变量设置为更高的数字，请编辑/etc/my.cnf文件并添加以下行:

To set this variable to a higher number, edit the /etc/my.cnf file and add the lines:

[mysqld]
open_files_limit = 5000

这篇关于错误代码:23打开文件时资源不足的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！