Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 16 Oct 2007 18:17:21 +0100
From:      Thomas Hurst <tom.hurst@clara.net>
To:        Peter Schuller <peter.schuller@infidyne.com>
Cc:        freebsd-current@freebsd.org
Subject:   Re: Status of MySQL on 7 w/o patches applied
Message-ID:  <20071016171721.GB6566@voi.aagh.net>
In-Reply-To: <20071016110642.GB54457@hyperion.scode.org>
References:  <20071016110642.GB54457@hyperion.scode.org>

next in thread | previous in thread | raw e-mail | index | archive | help

--HlL+5n6rz5pIUxbD
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Peter Schuller (peter.schuller@infidyne.com) wrote:

> My question is - what is the expected status of MySQL performance in
> FreeBSD 7 (without external patches) at this time?

Most if not all of the relevent patches were applied months ago.  We ran
MySQL in production for some time using both patched and later unpatched
7-CURRENT with ULE for a while, and normal performance was easily
comparible with Linux and Solaris.

We did see poor behavior with MySQL 5.1 and replication; the slave
thread needed periodic restarts because it would use progressively more
CPU and eventually fall behind, spending a long time in 'init' on every
query, which we didn't see in other OS's.  Whether this was FreeBSD's or
MySQL's fault I don't know, but one certainly didn't like the other.

> between 6.2 and 7-CURRENT. Selects were actually half as fast or less
> than 6.2 in this particular case (identical hardware).
>=20
> Now I realize I am not providing details here; I can most definitely
> provide a lot more detail. But first, is this *expected*?

If you're running with WITNESS, INVARIANTS and/or haven't set
MALLOC_PRODUCTION, sure.  RELENG_7 has these disabled, but CURRENT
always tends to default to rather aggressive debugging options.

> Are there patches that still have not been committed, or should we be
> expecting that FreeBSD 7 as it appears in CVS is comparable to Linux
> or better with MySQL?

The only unapplied patches I'm aware of is Jeff's select locking patch,
which didn't seem to help MySQL very much:

http://lists.freebsd.org/pipermail/freebsd-arch/2007-August/006702.html

--=20
Thomas 'Freaky' Hurst
    http://hur.st/

--HlL+5n6rz5pIUxbD
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (FreeBSD)

iD8DBQFHFPIhNBBHZ542MwQRAvkSAKDNbnrFT2l9saF+mQyVQZXV3OEHRACffcdw
lnWHyeUrVjqocHeN7AUvItI=
=oyQ2
-----END PGP SIGNATURE-----

--HlL+5n6rz5pIUxbD--



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