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>