Hi Toby, On 11/11/13 10:37, Toby Corkindale wrote: > On 11 November 2013 10:31, Russell Coker <[email protected]> wrote: >> On Fri, 8 Nov 2013, Arjen Lentz <[email protected]> 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/ _______________________________________________ luv-main mailing list [email protected] http://lists.luv.asn.au/listinfo/luv-main
