Re: MySQL 4.1.7 / OpenBSD 3.6-current AGAIN (errno 9) error! Help plz! :)

[Toni Mueller <openbsd-misc@oeko.net>]

Hi,

On Mon, 22.11.2004 at 16:57:12 +0500, Dennis Nasarov <pheonix@sysattack.com> wrote:
> I have read many articles in mailing lists and checks all advices i
> have found but my MySQL server AGAIN SAYS ME (errno: 9) :(
> 
> As i understood trouble with limiting openfiles-cur (ulimit etc...) i
> have add to my /etc/login.conf

> mysql:\
>         :datasize=infinity:\
>         :maxproc=infinity:\
>         :openfiles-cur=2048:\
>         :openfiles-max=8192:\

what about

 sysctl kern.maxfiles  ?


This could be lower than 8192. Eg. one one of my machines it's lower
than 2000. Also, I'm not sure that 8M stacksize is sufficient for
MySQL.


Best,
--Toni++