Hi Toby, On 11/11/13 10:37, Toby Corkindale wrote:
On 11 November 2013 10:31, Russell Coker <russell@coker.com.au> wrote:
On Fri, 8 Nov 2013, Arjen Lentz <arjen@lentz.com.au> wrote:
Some settings such as ulimit -n (open-files-limit) cannot be done from inside the daemon.
Sure they can, setrlimit(RLIMIT_NOFILE, ...
Why do you want to set an open files limit anyway? If a mysqld gets in a state where it opens more files than expected is having the open/pipe/accept call fail going to be the best thing for the system?
I suspect they were trying to *increase* the default, rather than lower it?
Indeed - and the reason for this is that mysqld is single-process, multi-threaded. Other daemons that need to open lots of files tend to be multi-process, which makes it easy to open lots of files. Typically the default limit is 1024 which is not sufficient for most production systems. Regards, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MariaDB/MySQL services Sane business strategy explorations at http://upstarta.com.au Personal blog at http://lentz.com.au/blog/