Problems with MySQL

[Jeremy Zawodny]

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