Problems with MySQL

[David Miller]

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