How to Fix (errno: 24, error: 17) in MySQL
来源:互联网 发布:android 拦截网络请求 编辑:程序博客网 时间:2024/05/29 17:47
How to Fix an (errno: 24) in MySQL
转自:http://info.solomonson.com/content/how-fix-errno-24-mysql
When creating a large number of partitions or tables, MySQL may mysteriously stop working and you find this type of error on/var/lib/mysql/$HOSTNAME.err
:
[ERROR] /usr/sbin/mysqld: Can't open file: './database/table.frm' (errno: 24)
errno: 24
simply means that too many files are open for the given process. There is a read-only mysql variable calledopen_files_limit
that will show how many open files are allowed by the mysqld
:
SHOW VARIABLES LIKE 'open%'
A lot systems set this to something very low, like 1024. Unfortunately, the following will NOT work:
SET open_files_limit=100000
MySQL will respond with:
ERROR 1238 (HY000): Variable 'open_files_limit' is a read only variable
However, it is possible to make a change to /etc/my.cnf
. This file may not exist, if not, just create it. Be sure it has the following contents:
[mysqld]open_files_limit = 100000
Then, be sure to restart mysql:
sudo /etc/init.d/mysql restart
Now, SHOW VARIABLES LIKE 'open%'
should show 100000. The number you use may be different.
A database is represented by a directory under the data directory, and the directory is intended for storage of table data.
The DROP DATABASE
statement will remove all table files and then remove the directory that represented the database. It will not, however, remove non-table files, whereby making it not possible to remove the directory.
MySQL displays an error message when it cannot remove the directory
you can really drop the database manually by removing any remaining files in the database directory and then the directory itself.
- How to Fix (errno: 24, error: 17) in MySQL
- How to Fix an (errno: 24) in MySQL
- How to fix "http error 403.14 - forbidden" in IIS7
- How to fix Rosetta stone error 2123 -- "This was an error in the application"
- How to fix Fatal error: Call to undefined function: mysql_connect() in Ubuntu
- How to Fix GIP.Trojan Windows Error
- how to fix error 25007 : loadlibraryshim()
- How to Fix QtWebKit4.dll DLL Error
- How to Fix QtWebKit4.dll DLL Error
- How to Fix asl.dll Error
- How to Fix d3dx9.dll Error
- How to Fix Installer Error 1721
- How to Completely Fix msvbvm60.dll Error
- How to Completely Fix olmapi32.dll Error
- How to Completely Fix qtwebkit4.dll Error
- How to Completely Fix privacyiconclient Error
- How to Completely Fix Windows Live Error
- How to Completely Fix kernel32.dll Error
- 去除svn蓝色问号
- Linux资源合集
- opencv 画渐变色
- linux上ln命令详细说明
- android中的ellipsize
- How to Fix (errno: 24, error: 17) in MySQL
- c++引用《笔记》
- #AWK#简单例子展示AWK是如何的灵活
- linux 怎样用命令关闭防火墙
- HDOJ 【C】2002 计算球体积
- IPhone程序发布到应用程序商店的流程
- Thread.sleep的原理
- Android 添加系统服务
- 大华笔试题.读写文件---是不是有bug啊?