Date: Mon, 5 May 2003 14:55:14 -0700 From: Jeremy Zawodny <jzawodn@yahoo-inc.com> To: "[IFMX] Jeremy" <jeremy@inframatrix.com> Cc: freebsd-database@freebsd.org Subject: Re: Problems with MySQL Message-ID: <20030505145514.B12200@yahoo-inc.com> In-Reply-To: <06be01c31171$120dd960$0402a8c0@L5>; from jeremy@inframatrix.com on Sat, May 03, 2003 at 08:39:41PM %2B0800 References: <06be01c31171$120dd960$0402a8c0@L5>
next in thread | previous in thread | raw e-mail | index | archive | help
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?20030505145514.B12200>