From owner-freebsd-stable@FreeBSD.ORG Sat Jun 11 05:02:11 2005 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0EBED16A41C; Sat, 11 Jun 2005 05:02:11 +0000 (GMT) (envelope-from delphij@frontfree.net) Received: from tarsier.geekcn.org (tarsier.geekcn.org [210.51.165.229]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8B76443D4C; Sat, 11 Jun 2005 05:02:10 +0000 (GMT) (envelope-from delphij@frontfree.net) Received: from beastie.frontfree.net (unknown [219.239.99.7]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by tarsier.geekcn.org (Postfix) with ESMTP id E6D69EB1E0A; Sat, 11 Jun 2005 13:02:07 +0800 (CST) Received: from localhost (localhost.frontfree.net [127.0.0.1]) by beastie.frontfree.net (Postfix) with ESMTP id A3303132A99; Sat, 11 Jun 2005 13:02:04 +0800 (CST) Received: from beastie.frontfree.net ([127.0.0.1]) by localhost (beastie.frontfree.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 68988-10; Sat, 11 Jun 2005 13:01:59 +0800 (CST) Received: from [172.21.25.83] (unknown [172.21.25.83]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by beastie.frontfree.net (Postfix) with ESMTP id DC845131298; Sat, 11 Jun 2005 13:01:57 +0800 (CST) From: Xin LI To: Greg 'groggy' Lehey In-Reply-To: <20050611041947.GP87456@wantadilla.lemis.com> References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> <20050611041947.GP87456@wantadilla.lemis.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-n0NyXPbd60NofL7oXG5D" Organization: The FreeBSD Simplified Chinese Project Date: Sat, 11 Jun 2005 13:01:54 +0800 Message-Id: <1118466114.695.3.camel@spirit> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 FreeBSD GNOME Team Port X-Virus-Scanned: amavisd-new at frontfree.net Cc: Steve Roome , freebsd-stable@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: delphij@delphij.net List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 11 Jun 2005 05:02:11 -0000 --=-n0NyXPbd60NofL7oXG5D Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, Greg, =E5=9C=A8 2005-06-11=E5=85=AD=E7=9A=84 13:49 +0930=EF=BC=8CGreg 'groggy' Le= hey=E5=86=99=E9=81=93=EF=BC=9A > On Friday, 10 June 2005 at 18:05:37 +0100, Steve Roome wrote: > > We're using mostly: > > > > 5.4-STABLE FreeBSD 5.4-STABLE #0: Mon Jun 6 12:22:18 BST 2005 > > > > This is on a Dell PowerEdge 2850. (2 * 2.8 GHz Xeons, 4GB ram, disks), > > we've been keeping up with stable because supposedly all these new > > fixes to threading will help us out here. >=20 > What's the current malloc config for 5.4? Last time I saw this kind > of comparison, it proved to be due to malloc debugging. That was on > -CURRENT, though. See http://www.lemis.com/grog/diary-dec2004.html#14 > for more details. The malloc config for 5.4 is aj IIRC. Maybe we should do a gprof'ed build of mysql as well as ktrace dump of a mysql daemon to figure out what was happening? Actually the test team at my company has found the exact problem within a recent FreeBSD (5.4-R) vs CentOS (4.0) benchmark test, but they have not arranged the same hardware for me yet to figure out why. Cheers, --=20 Xin LI http://www.delphij.net/ --=-n0NyXPbd60NofL7oXG5D Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQBCqnBC/cVsHxFZiIoRAh26AJ92pBHkcT+R/KHBhII2AlJoE0j53gCgi6d4 wHERZjOJfyqfB9zRtzFdsfo= =2mPX -----END PGP SIGNATURE----- --=-n0NyXPbd60NofL7oXG5D--