Re: Mysql dump error in VPS [message #7329 is a reply to message #7304] |
Wed, 11 October 2006 08:11 ![Go to previous message Go to previous message](/theme/ovz3/images/up.png) ![Go to next message Go to previous message](/theme/ovz3/images/down.png) |
dev
Messages: 1693 Registered: September 2005 Location: Moscow
|
Senior Member |
![5072133](/theme/ovz3/images/icq.png)
|
|
Not all the resources are set unlimited.
You have ulimit for files = 1024:
[root@v1 ~]# ulimit -a
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) unlimited
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) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 16317
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
So mysqld can't open more than 1024 files.
To fix it you need to run /usr/bin/mysqld_safe with --open-files-limit argument or
or specify
open-files-limit=4096
in /etc/my.cnf
But you added open_files_limit, not open-files-limit.
|
|
|