From owner-freebsd-current@FreeBSD.ORG Tue Oct 16 17:17:23 2007 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3516716A417 for ; Tue, 16 Oct 2007 17:17:23 +0000 (UTC) (envelope-from tom.hurst@clara.net) Received: from spork.qfe3.net (spork.qfe3.net [212.13.207.101]) by mx1.freebsd.org (Postfix) with ESMTP id EC7B213C468 for ; Tue, 16 Oct 2007 17:17:22 +0000 (UTC) (envelope-from tom.hurst@clara.net) Received: from [81.104.144.87] (helo=voi.aagh.net) by spork.qfe3.net with esmtp (Exim 4.66 (FreeBSD)) (envelope-from ) id 1Ihq2j-0000bk-Qd; Tue, 16 Oct 2007 18:17:21 +0100 Received: from freaky by voi.aagh.net with local (Exim 4.67 (FreeBSD)) (envelope-from ) id 1Ihq2j-0002GD-LM; Tue, 16 Oct 2007 18:17:21 +0100 Date: Tue, 16 Oct 2007 18:17:21 +0100 From: Thomas Hurst To: Peter Schuller Message-ID: <20071016171721.GB6566@voi.aagh.net> Mail-Followup-To: Peter Schuller , freebsd-current@freebsd.org References: <20071016110642.GB54457@hyperion.scode.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="HlL+5n6rz5pIUxbD" Content-Disposition: inline In-Reply-To: <20071016110642.GB54457@hyperion.scode.org> Organization: Not much. User-Agent: Mutt/1.5.16 (2007-06-09) Sender: Thomas Hurst Cc: freebsd-current@freebsd.org Subject: Re: Status of MySQL on 7 w/o patches applied X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Oct 2007 17:17:23 -0000 --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--