Date: Tue, 6 May 2003 05:58:30 +0800 From: "[IFMX] Jeremy" <jeremy@inframatrix.com> To: "Jeremy Zawodny" <jzawodn@yahoo-inc.com> Cc: freebsd-database@freebsd.org Subject: Re: Problems with MySQL Message-ID: <0b4d01c31351$779d1d90$0402a8c0@L5> References: <06be01c31171$120dd960$0402a8c0@L5> <20030505145514.B12200@yahoo-inc.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <jzawodn@yahoo-inc.com>
To: "[IFMX] Jeremy" <jeremy@inframatrix.com>
Cc: <freebsd-database@freebsd.org>
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, <jzawodn@yahoo-inc.com>
> Technical Yahoo - Yahoo Search
> Desk: (408) 349-7878 Cell: (408) 685-5936
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?0b4d01c31351$779d1d90$0402a8c0>