Problems with MySQL

[[IFMX] Jeremy]

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 at yahoo-inc.com>
To: "[IFMX] Jeremy" <jeremy at inframatrix.com>
Cc: <freebsd-database at 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 at yahoo-inc.com>
> Technical Yahoo - Yahoo Search
> Desk: (408) 349-7878  Cell: (408) 685-5936