Bug #26114 mysqldump failes with "too many open files" on busy server
| Submitted: | 6 Feb 2007 13:28 | Modified: | 12 Apr 2007 16:25 |
|---|---|---|---|
| Reporter: | Kristian Koehntopp | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: mysqldump Command-line Client | Severity: | S2 (Serious) |
| Version: | 5.0.26 | OS: | Linux (Centos 4.3) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | bfsm_2007_02_15 | ||
[6 Feb 2007 13:28]
Kristian Koehntopp
[6 Feb 2007 14:33]
Valeriy Kravchuk
Thank you for a problem report. Please, send the results of ulimit -a from the session of the same user that runs mysqld.
[6 Feb 2007 14:41]
Kristian Koehntopp
[root@bc08rodb-01 ~]# su - mysql -bash-3.00$ ulimit -a -S core file size (blocks, -c) 0 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 (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 65535 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited -bash-3.00$ ulimit -a -H 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) 32000 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 65535 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
[6 Feb 2007 15:09]
Sergei Golubchik
This is apparently a duplicate of - ealier submitter - bug#26026
[6 Feb 2007 16:08]
Valeriy Kravchuk
OK, so you may have up to 1024 open files. How many tables do you have in that database? If you have, say, only 100, and 3+ file handles are used per each table while mysqldump works, then I agree - we have a problem here. Anyway, this problem can be easily solved (on Linux), as it was already pointed out.
[7 Mar 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.078 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.