Innodb:error number means ' Too many open files '.--Reprint

I. Description of the problem

the Backup program executes the error when it rolls forward. (-apply-log)

Innodb:errornumber means ' Too many open files '.

Innodb:some OperatingSystem error numbers is described at

InnoDB:
Http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html

Innodb:file NAME/HOME/NICE/BACKUP/MYSQL/VAR.20121211021656/USER_DB_20121123/TUSER_LIKE_CORE.IBD

Innodb:file operationcall: ' Open '.

Innodb:cannot continueoperation.

Innobackup:error:

Two. Problem analysis

The openfiles is too small to open.

MySQL Open_file_limit is subject to the following parameters

Configurations in Max_connections, Table_open_cache, Open_files_limit, and/etc/security/limits.conf.

The relationship between Max_connections and Table_open_cache and Open_files_limit:

Max_1 = ten + max_connections + table_cache * 2;

Max_2 = max_connections * 5;

Max_3 = max_os_open_files;//operating system The maximum allowed open file handle (file descriptor) for a single process.

open_files_limit= Max (max_1, max_2) > Max_3? Max_3:max (Max_1, max_2);

Comprehensive analysis found that Open_files_limit | 10240

And now the IBD table is 10,800.

Three. Problem solving

1.my.cnf Configuration Open_files_limit = 20480

Restart MySQL found no change, Open_files_limit | 10240.

2.ulimit-a

Core file size (blocks,-c) Unlimited
Data seg Size (Kbytes,-D) Unlimited
File size (blocks,-f) Unlimited
Pending signals (-i) 1024
Max locked Memory (Kbytes, L) 32
Max memory Size (Kbytes,-m) unlimited
Open files (-N) 1024
Pipe Size (bytes,-p) 8
POSIX message queues (bytes,-Q) 819200
Stack size (Kbytes,-s) 10240
CPU time (seconds,-t) unlimited
MAX User Processes (-u) 137216
Virtual Memory (Kbytes,-V) Unlimited
File locks (-X) Unlimited

3.vi/etc/security/limits.conf, add

MySQL Soft nofile 8192
MySQL Hard nofile 20480

4. after the first three steps, restart MySQL.

Restart MySQL discovery, Open_files_limit | 20480.

5. Modifying the OS user profile

After the first four steps, though open_files_limit in MySQL | 20480, but Ibbackup still in front of the times wrong. Newspaper, Open_file not enough. Doubts are still not in force.

Ulimit-a

Core file size (blocks,-c) Unlimited
Data seg Size (Kbytes,-D) Unlimited
File size (blocks,-f) Unlimited
Pending signals (-i) 1024
Max locked Memory (Kbytes, L) 32
Max memory Size (Kbytes,-m) unlimited
Open files (-N) 1024
Pipe Size (bytes,-p) 8
POSIX message queues (bytes,-Q) 819200
Stack size (Kbytes,-s) 10240
CPU time (seconds,-t) unlimited
MAX User Processes (-u) 137216
Virtual Memory (Kbytes,-V) Unlimited
File locks (-X) Unlimited

Then, modify the OS user profile

See. Bash_profile,. BASHRC,/ETC/BASHRC, respectively;

Found,. Bash_profile called. BASHRC,. BASHRC Call/ETC/BASHRC

Found that there were/etc/bashrc in the

Ulimit-s-C Unlimited >/dev/null 2>&1
After this line is added

Ulimit-n 20480 >/dev/null 2>&1

6. Restart MySQL, perform backup procedures, in--apply-log, or error, reported, Open_file not enough

Innodb:errornumber means ' Too many open files '.

Innodb:some OperatingSystem error numbers is described at

Innodb:http://dev.mysql.com/doc/mysql/en/operating_system_error_codes.html

7. Modify the Innodb_open_files parameter

Before this parameter is set to 500. This modification to 1000.

Restart MySQL to solve the problem

Four. About operating_system_error_codes.html

Linux System Error Codes

The following tableprovides a list of some common Linux system error codes. For a more completelist, see Linux Source code.

Number	Macro	Description
1	Eperm	Operation not permitted
2	ENOENT	No such file or directory
3	Esrch	No such process
4	Eintr	Interrupted system call
5	EIO	I/O error
6	Enxio	No such device or address
7	E2big	ARG list too long
8	Enoexec	Exec Format Error
9	EBADF	Bad file number
10	Echild	No Child Processes
11	Eagain	Try again
12	Enomem	Out of memory
13	Eacces	Permission denied
14	Efault	Bad address
15	Enotblk	Block Device required
16	Ebusy	Device or resource busy
17	Eexist	File exists
18	Exdev	Cross-device Link
19	Enodev	No such device
20	Enotdir	Not a directory
21st	Eisdir	is a directory
22	EINVAL	Invalid argument
23	Enfile	File Table Overflow
24	Emfile	Too Many open files
25	Enotty	Inappropriate IOCTL for device
26	Etxtbsy	Text file Busy
27	Efbig	File too large
28	ENOSPC	No space left on device
29	Espipe	Illegal seek
30	Erofs	Read-only File System
31	Emlink	Too many links

Disclaimer: This document can be changed at will, but must be signed by the original author

Phoenix Dancer qq:578989855

Innodb:error number means ' Too many open files '.--Reprint