Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 3 May 2003 14:20:46 -0400 (EDT)
From:      David Miller <fd@d.sparks.net>
To:        "[IFMX] Jeremy" <jeremy@inframatrix.com>
Cc:        freebsd-database@freebsd.org
Subject:   Re: Problems with MySQL
Message-ID:  <Pine.BSF.4.21.0305031418530.7622-100000@search.sparks.net>
In-Reply-To: <06be01c31171$120dd960$0402a8c0@L5>

next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, 3 May 2003, [IFMX] Jeremy wrote:

> Hi,
> 
> I run a small hosting service and I have serious problems with MySQL. I
> installed version 3.23.53 using the ports defaults and did not add any
> optimizations except tuning the back_log, max_connections and
> connection_timeout variables. My clients experience occation connection
> drops, either resulting in "cannot connect to database" or "no database
> selected". I have absolutely no idea of what's happening, nothing is wrong
> in the logs and the problem happens randomly. Any idea? Thanks in advance

Sounds like you might be running out of file descriptors or something
similar - too many processes or something.  Check the first with sysctl.

--- David



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0305031418530.7622-100000>