From owner-freebsd-database@FreeBSD.ORG Mon May 5 14:55:18 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 C96D737B401 for ; Mon, 5 May 2003 14:55:18 -0700 (PDT) Received: from museful.corp.yahoo.com (museful.corp.yahoo.com [216.145.52.107]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6A00D43F85 for ; Mon, 5 May 2003 14:55:18 -0700 (PDT) (envelope-from jzawodn@yahoo-inc.com) Received: (from jzawodn@localhost) by museful.corp.yahoo.com (8.11.6/8.11.1) id h45LtEB12282; Mon, 5 May 2003 14:55:14 -0700 (PDT) (envelope-from jzawodn) Date: Mon, 5 May 2003 14:55:14 -0700 From: Jeremy Zawodny To: "[IFMX] Jeremy" Message-ID: <20030505145514.B12200@yahoo-inc.com> References: <06be01c31171$120dd960$0402a8c0@L5> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <06be01c31171$120dd960$0402a8c0@L5>; from jeremy@inframatrix.com on Sat, May 03, 2003 at 08:39:41PM +0800 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: Mon, 05 May 2003 21:55:19 -0000 On Sat, May 03, 2003 at 08:39:41PM +0800, [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 There's some background on the problems you're likely hitting here: http://jeremy.zawodny.com/blog/archives/000203.html http://jeremy.zawodny.com/blog/archives/000458.html http://jeremy.zawodny.com/blog/archives/000697.html In short, I'd suggest using 4.0.xx and compiling with LinuxThreads support. That'll probably solve some (if not all) of the problems. It has done wonders for us and other FreeBSD/MySQL shops I know of. Jeremy -- Jeremy D. Zawodny, Technical Yahoo - Yahoo Search Desk: (408) 349-7878 Cell: (408) 685-5936