Hi, I think you misunderstood /proc/sys/fs/file-max meaning, it IS an averall machine limit, not per process. From linux kernel documentation (/usr/src/linux/Documentation/sysctl/fs.txt): "file-max & file-nr:
The kernel allocates file handles dynamically, but as yet it doesn't free them again. The value in file-max denotes the maximum number of file- handles that the Linux kernel will allocate. When you get lots of error messages about running out of file handles, you might want to increase this limit. The three values in file-nr denote the number of allocated file handles, the number of used file handles and the maximum number of file handles. When the allocated file handles come close to the maximum, but the number of actually used ones is far behind, you've encountered a peak in your usage of file handles and you don't need to increase the maximum." Whatever value you set with ulimit, you won't get any error message until the system actually reaches file-max limit. It will then deny any new file open (not just those coming from mysqld). Hope this helps, Joseph Bueno Martin Waite wrote:
Hi,
Does anyone know what the story is for file-descriptor limits
on Linux ?
I read in
http://www.xenoclast.org/doc/benchmark/HTTP-benchmarking-HOWTO/node7.html
that root needs to set /proc/sys/fs/file-max to a high value in order that "ulimit -n NNNN" will work.
However, on a Debian Woody box (2.4 kernel), this doesn't seem to be necessary. As root, I can set the value as high as I want (up to about 63000) regardless of the value in /proc/sys/fs/file-max.
Also, these are per-process limits. What is the overall machine limit - assuming there is one ?
These questions are related to MySQL, SQL, etc. Honest.
==
Martin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
