From owner-freebsd-database@FreeBSD.ORG Sat May 3 11:20:47 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1563537B401 for ; Sat, 3 May 2003 11:20:47 -0700 (PDT) Received: from search.sparks.net (search.sparks.net [207.5.180.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9093943FBD for ; Sat, 3 May 2003 11:20:46 -0700 (PDT) (envelope-from dmiller@sparks.net) Received: by search.sparks.net (Postfix, from userid 100) id 0DCA3A903; Sat, 3 May 2003 14:20:46 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id 0BADCA902; Sat, 3 May 2003 14:20:46 -0400 (EDT) Date: Sat, 3 May 2003 14:20:46 -0400 (EDT) From: David Miller X-Sender: dmiller@search.sparks.net To: "[IFMX] Jeremy" In-Reply-To: <06be01c31171$120dd960$0402a8c0@L5> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: dmiller@sparks.net cc: freebsd-database@freebsd.org Subject: Re: Problems with MySQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 03 May 2003 18:20:47 -0000 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