From owner-freebsd-database@FreeBSD.ORG Mon May 5 14:58:35 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 90B4537B401 for ; Mon, 5 May 2003 14:58:35 -0700 (PDT) Received: from libra.i-cable.com (libra.i-cable.com [203.83.111.73]) by mx1.FreeBSD.org (Postfix) with SMTP id 533BA43FCB for ; Mon, 5 May 2003 14:58:34 -0700 (PDT) (envelope-from jeremy@inframatrix.com) Received: (qmail 23085 invoked by uid 706); 5 May 2003 21:58:32 -0000 Received: from cm61-10-38-73.hkcable.com.hk (HELO L5) (61.10.38.73) by 0 with SMTP; 5 May 2003 21:58:31 -0000 Message-ID: <0b4d01c31351$779d1d90$0402a8c0@L5> From: "[IFMX] Jeremy" To: "Jeremy Zawodny" References: <06be01c31171$120dd960$0402a8c0@L5> <20030505145514.B12200@yahoo-inc.com> Date: Tue, 6 May 2003 05:58:30 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 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:58:35 -0000 Hi, Thank you very much for your reply. I will try it out later today, but I would like to know how to move databases from 3.x to 4.x? We move databases between servers with 3.x only by copying, is it possible to move in that way for 4.x? Thanks - Jeremy ________________________ inframatrix internet solutions http://www.inframatrix.com/ ----- Original Message ----- From: "Jeremy Zawodny" To: "[IFMX] Jeremy" Cc: Sent: Tuesday, May 06, 2003 5:55 AM Subject: Re: Problems with MySQL > 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