On Thu, 7 Sep 2006, Matthew Peltzer wrote:
> On 9/7/06, Tim Donahue <[EMAIL PROTECTED]> wrote:
> > Make sure that you have your 'open-files-limit' parameter set to a sane
> > value in your my.cnf. If you don't have anything set for that limit
> > the default is extremely low (so low that using views tended to not
> > work on my dev box). I have been using "open-files-limit = 8192",
> > however YMMV.
>
> FYI, I was suggested to use this setting to correct what looked like
> all the databases in mysql getting DROPed after a short time (an hour
> or so) of light use. I soon after noticed this in
> /var/mysql/$host.err the file:
>
> > 060830 22:37:02 [Warning] Could not increase number of max_open_files
> > to more than 1772 (request: 8192)
>
> ...so I bumped it down to 1024 and all has been well enough.
Of course, there is a per process limit (see ulimit and login.conf)
and a system wide limit of open files (sysctl kern.maxfiles; guess
what its default value is).
-Otto
