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 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 From owner-freebsd-database@FreeBSD.ORG Mon May 5 15:02:26 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 A0D9237B401 for ; Mon, 5 May 2003 15:02:26 -0700 (PDT) Received: from museful.corp.yahoo.com (museful.corp.yahoo.com [216.145.52.107]) by mx1.FreeBSD.org (Postfix) with ESMTP id B83BF43FB1 for ; Mon, 5 May 2003 15:02:25 -0700 (PDT) (envelope-from jzawodn@yahoo-inc.com) Received: (from jzawodn@localhost) by museful.corp.yahoo.com (8.11.6/8.11.1) id h45M2MK12457; Mon, 5 May 2003 15:02:22 -0700 (PDT) (envelope-from jzawodn) Date: Mon, 5 May 2003 15:02:22 -0700 From: Jeremy Zawodny To: "[IFMX] Jeremy" Message-ID: <20030505150222.A12419@yahoo-inc.com> References: <06be01c31171$120dd960$0402a8c0@L5> <20030505145514.B12200@yahoo-inc.com> <0b4d01c31351$779d1d90$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: <0b4d01c31351$779d1d90$0402a8c0@L5>; from jeremy@inframatrix.com on Tue, May 06, 2003 at 05:58:30AM +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 22:02:27 -0000 On Tue, May 06, 2003 at 05:58:30AM +0800, [IFMX] Jeremy wrote: > 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 Yup. The file format is the same, so upgrading to 4.0.xx is painless. Make a backup first, of course, but I doubt you'll need it. Jeremy -- Jeremy D. Zawodny, Technical Yahoo - Yahoo Search Desk: (408) 349-7878 Cell: (408) 685-5936 From owner-freebsd-database@FreeBSD.ORG Mon May 5 15:05:44 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 60FC637B401 for ; Mon, 5 May 2003 15:05:44 -0700 (PDT) Received: from libra.i-cable.com (libra.i-cable.com [203.83.111.73]) by mx1.FreeBSD.org (Postfix) with SMTP id 22C0243FA3 for ; Mon, 5 May 2003 15:05:43 -0700 (PDT) (envelope-from jeremy@inframatrix.com) Received: (qmail 24033 invoked by uid 706); 5 May 2003 22:05:42 -0000 Received: from cm61-10-38-73.hkcable.com.hk (HELO L5) (61.10.38.73) by 0 with SMTP; 5 May 2003 22:05:41 -0000 Message-ID: <0b5301c31352$77cb15f0$0402a8c0@L5> From: "[IFMX] Jeremy" To: "Jeremy Zawodny" References: <06be01c31171$120dd960$0402a8c0@L5> <20030505145514.B12200@yahoo-inc.com> <0b4d01c31351$779d1d90$0402a8c0@L5> <20030505150222.A12419@yahoo-inc.com> Date: Tue, 6 May 2003 06:05:40 +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 22:05:44 -0000 Thanks a lot for your help, hope I'll get all the problems sorted out :) - Jeremy ________________________ inframatrix internet solutions http://www.inframatrix.com/ ----- Original Message ----- From: "Jeremy Zawodny" To: "[IFMX] Jeremy" Cc: Sent: Tuesday, May 06, 2003 6:02 AM Subject: Re: Problems with MySQL > On Tue, May 06, 2003 at 05:58:30AM +0800, [IFMX] Jeremy wrote: > > 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 > > Yup. The file format is the same, so upgrading to 4.0.xx is painless. > Make a backup first, of course, but I doubt you'll need it. > > Jeremy > -- > Jeremy D. Zawodny, > Technical Yahoo - Yahoo Search > Desk: (408) 349-7878 Cell: (408) 685-5936