From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 09:58:11 2005 Return-Path: X-Original-To: current@freebsd.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1F2F916A41F for ; Wed, 26 Oct 2005 09:58: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 96A4F43D53 for ; Wed, 26 Oct 2005 09:58:07 +0000 (GMT) (envelope-from delphij@frontfree.net) Received: from localhost (tarsier.geekcn.org [210.51.165.229]) by tarsier.geekcn.org (Postfix) with ESMTP id D55C6EB1056 for ; Wed, 26 Oct 2005 17:58:05 +0800 (CST) Received: from tarsier.geekcn.org ([210.51.165.229]) by localhost (mail.geekcn.org [210.51.165.229]) (amavisd-new, port 10024) with ESMTP id 69507-18 for ; Wed, 26 Oct 2005 17:58:04 +0800 (CST) Received: from beastie.frontfree.net (unknown [211.71.95.7]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by tarsier.geekcn.org (Postfix) with ESMTP id 6E9A2EB1042 for ; Wed, 26 Oct 2005 17:58:02 +0800 (CST) Received: from localhost (localhost.frontfree.net [127.0.0.1]) by beastie.frontfree.net (Postfix) with ESMTP id 1483913262D; Wed, 26 Oct 2005 17:57:56 +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 57691-02; Wed, 26 Oct 2005 17:57:55 +0800 (CST) Received: from [10.217.12.68] (sina152-194.staff.sina.com.cn [61.135.152.194]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by beastie.frontfree.net (Postfix) with ESMTP id A5306132548; Wed, 26 Oct 2005 17:57:53 +0800 (CST) From: Xin LI To: Marian Hettwer In-Reply-To: <435F48DA.6060009@kernel32.de> References: <435F48DA.6060009@kernel32.de> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-txlcpLehz5KxV5pljZD4" Organization: The FreeBSD Simplified Chinese Project Date: Wed, 26 Oct 2005 17:57:48 +0800 Message-Id: <1130320668.810.87.camel@spirit> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 FreeBSD GNOME Team Port X-Virus-Scanned: amavisd-new at frontfree.net X-Virus-Scanned: amavisd-new at geekcn.org Cc: current@freebsd.org Subject: Re: MySQL Performance 6.0rc1 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: Wed, 26 Oct 2005 09:58:11 -0000 --=-txlcpLehz5KxV5pljZD4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, Marian, =E5=9C=A8 2005-10-26=E4=B8=89=E7=9A=84 11:14 +0200=EF=BC=8CMarian Hettwer= =E5=86=99=E9=81=93=EF=BC=9A > Hi Folks, >=20 > I'm using RC1 on some of my test servers and workstations. So far, it=20 > runs very good (as in stable and fast) :) > However, I thought of doing a small benchmark of MySQL in comparison to=20 > Linux 2.6.8 (Debian Sarge) and the results are kinda... shocking. [...] > Any Ideas where this huge difference comes from? Did I oversee some=20 > debugging features still active in RC1 ? There are many factors that can affect the performance of MySQL. Would you please post the output of "dumpfs /var | head -n 21" on your server? (Replace /var with whatever mountpoint that your database is stored in). Some observations that I think can affect MySQL performance: - Our malloc(3) implementation might be sub-optimal for the workload. - Lack of some POSIX system call which was implemented in other ways (e.g. we do not have fsyncdata yet) - Some detailed implementation difference between our and Linux's threading library, or MySQL itself. I think David (davidxu@) had worked on performance of MySQL and he may have some suggestions. BTW. What file system are you using on your Debian test? What's the mount options? Cheers, --=20 Xin LI http://www.delphij.net/ --=-txlcpLehz5KxV5pljZD4 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQBDX1Mc/cVsHxFZiIoRAnmpAJ9pRiNMFA2kGhPYaQS7qia4C85BkACgkGAx jiipPcMlglt+rebE/K4Ir8c= =+mFn -----END PGP SIGNATURE----- --=-txlcpLehz5KxV5pljZD4--