Re: mysql dying all the time..

["Justin C. Darby" <justin@gna.net>]

I disagree -- the ulimit line has no effect with the file descriptor
problem I'm having. (I've tryed it both ways.)

Justin C. Darby

On Thu, 31 Aug 2000, eric jackson wrote:

> On Thu, 31 Aug 2000, Justin C. Darby wrote:
> 
> > I'm running 2.7-current on a machine, I think i've got the mysql problem
> > fixed (it's a cheesy hack, but it works for me):
> > 
> > /usr/sbin/sysctl -w kern.maxfiles=8192
> > 
> > Mabye this will help others?  It takes an ENORMOUS ammount of time for the
> > sockets that mysql closes to get out of "TIME_WAIT" for some reason --
> > cause is unknown to me, but they do eventually get that far.  By
> > increasing the max files, I'm not running into the:
> > 
> > 000831 21:00:43  Error in accept: Bad file descriptor
> > 
> > problem, so, I'm going to assume that OpenBSD (for some reason) isin't
> > automatically sensing that it needs to allocate more FD's, and it's
> > causing a wallop of problems for mysql -- by doing this it seems that the 
> > problem is 'fixed', as in there's enough FD's available to where mysql
> > isin't forced into using a dirty one that's still in "TIME_WAIT".
> 
> Problem really is that mysql isnt noticing that it has hit its limits and
> handling things properly. The way to solve this is correctly is in
> safe_mysqld, uncomment the ulimit lines which will increase limits only
> for mysql and not affect the overall system.
> 
> this is how the port does it now.
> 
> 		eric
> 
> 
> > 
> > Justin C. Darby
> > 
> > 
> > 
> 
> 
> 
>