Home > Database > Mysql Tutorial > mysql报错Out of resources when opening file './xxx#P

mysql报错Out of resources when opening file './xxx#P

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 16:36:22
Original
1299 people have browsed it

环境: ubuntu 12.04 mysql 5.5 抛出错误: Out of resources when opening file './xxx/Users#P#pid_78.MYD' (Errcode: 24) 查了一下,这个是跟打开文件数量有关,设置大点就好。 2个要点: 1、操作系统针对mysql用户的open files 数量增大 2、my.cnf 文件

环境:

ubuntu 12.04

mysql 5.5

抛出错误:


Out of resources when opening file './xxx/Users#P#pid_78.MYD' (Errcode: 24)
Copy after login

查了一下,这个是跟打开文件数量有关,设置大点就好。

2个要点:

1、操作系统针对mysql用户的open files 数量增大

2、my.cnf 文件里配置 open-files-limit 

操作过程:


vim /etc/security/limits.conf
Copy after login

加入内容:


mysql soft nofile 102400
mysql hard nofile 102400
Copy after login

vim /etc/mysql/my.cnf
Copy after login

在[mysqld]下加入内容:


open-files-limit=102400
Copy after login

 淡定的reboot就好。

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template