Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 22 Mar 2004 13:34:32 -0700 (MST)
From:      "Kris Gale" <kris-fbsd@asn.net>
To:        "Daniel Eischen" <eischen@vigrid.com>
Cc:        freebsd-threads@freebsd.org
Subject:   Re: Loaded MySQL 4.0.18 w/ KSE running nicely
Message-ID:  <51632.68.14.252.60.1079987672.squirrel@mail.asn.net>
In-Reply-To: <Pine.GSO.4.10.10403221447420.25232-100000@pcnet5.pcnet.com>
References:  <20040322175637.GA57230@voi.aagh.net> <Pine.GSO.4.10.10403221447420.25232-100000@pcnet5.pcnet.com>

next in thread | previous in thread | raw e-mail | index | archive | help
> WRT compiling/linking/libmap.conf.  I have Mysql 4.0 running
> on -current just fine, and so does the mysql maintainer.

This is something I've said on this list quite a few times, but it
may help shed some light on this situation:

MySQL does run very well on -current, even handling huge loads
in terms of queries per second.  The problem is with surges of
incoming connections.  If multiple clients try to connect
simultaneously, things bog down terribly.

Up until a few weeks ago, a surge of incoming connections
would end up causing my -current system to panic and reboot
about half of the time.

A recent fix must have corrected this, because I can't reproduce
the kernel panic (which I could do very consistently before).
However, the problem with things bogging down has gotten
much, much worse.

I've posted a backtrace of the crash dump to the list, and also
a perl script which I was using to see the problems.

If someone is just using a small number of clients (or script that
just makes few connections) to test MySQL, it will appear to run
beautifully.  The performance in such a scenario is drastically
better than under 4.x.

Kris



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?51632.68.14.252.60.1079987672.squirrel>