From owner-freebsd-stable@FreeBSD.ORG Tue Jun 28 19:02:13 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 208CB16A41C for ; Tue, 28 Jun 2005 19:02:13 +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 85DDA43D49 for ; Tue, 28 Jun 2005 19:02:12 +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 E7B0FEB2641 for ; Wed, 29 Jun 2005 03:02:06 +0800 (CST) Received: from localhost (localhost.frontfree.net [127.0.0.1]) by beastie.frontfree.net (Postfix) with ESMTP id 2EED1132D7B; Wed, 29 Jun 2005 03:02:02 +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 21955-04; Wed, 29 Jun 2005 03:01:53 +0800 (CST) Received: by beastie.frontfree.net (Postfix, from userid 1001) id D2244132AC1; Wed, 29 Jun 2005 03:01:51 +0800 (CST) Date: Wed, 29 Jun 2005 03:01:51 +0800 From: Xin LI To: Roman Neuhauser Message-ID: <20050628190151.GA22060@frontfree.net> References: <1dbad315050621051525f4c6fc@mail.gmail.com> <200506211451.j5LEpA2W024350@lurza.secnetix.de> <20050628092126.GB48140@isis.sigpipe.cz> <1119973124.7900.20.camel@zappa.Chelsea-Ct.Org> <20050628163928.GA51923@isis.sigpipe.cz> <1119978184.7900.36.camel@zappa.Chelsea-Ct.Org> <20050628171739.GC51923@isis.sigpipe.cz> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="0F1p//8PRICkK4MW" Content-Disposition: inline In-Reply-To: <20050628171739.GC51923@isis.sigpipe.cz> User-Agent: Mutt/1.4.2.1i X-GPG-key-ID/Fingerprint: 0xCAEEB8C0 / 43B8 B703 B8DD 0231 B333 DC28 39FB 93A0 CAEE B8C0 X-GPG-Public-Key: http://www.delphij.net/delphij.asc X-Operating-System: FreeBSD beastie.frontfree.net 5.4-RELEASE-p1 FreeBSD 5.4-RELEASE-p1 #1: Fri May 27 00:47:15 CST 2005 delphij@beastie.frontfree.net:/usr/obj/usr/src/sys/BEASTIE i386 X-URL: http://www.delphij.net X-By: delphij@beastie.frontfree.net X-Location: Beijing, China X-Virus-Scanned: amavisd-new at frontfree.net Cc: freebsd-stable@freebsd.org, Michael Schuh Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Jun 2005 19:02:13 -0000 --0F1p//8PRICkK4MW Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Jun 28, 2005 at 07:17:39PM +0200, Roman Neuhauser wrote: > # paul@gromit.dlib.vt.edu / 2005-06-28 13:03:04 -0400: > > On Tue, 2005-06-28 at 18:39 +0200, Roman Neuhauser wrote: > > > > My apologies if it wasn't clear, but I was responding to your apparent > > assertion that location does not matter in disk performance benchmarks. >=20 > We seem to have a misunderstaning, I didn't mean anything like that. >=20 > > > I just wish people here were less defensive, that's all. > >=20 > > What you see as being defensive I see as being rigorous. If someone is > > making a claim based upon a performance benchmark, people will quiz the > > person conducting the benchmark to ascertain exactly how it has been > > undertaken. To put any stock in a benchmark result, it is important to > > be able to convince yourself it is a meaningful result. Well, at least > > most people I've encountered believe that to be the case. >=20 > Say I install FreeBSD (using default partitions), install MySQL from > a package on the CD, run a stress test, collect numbers, then > repeat the process with a Linux installed over the previous FreeBSD > installation, and find out that FreeBSD allows the MySQL server > process 1/3 queries less, what (if anything) will be wrong in my > claim that MySQL/FreeBSD is slower than MySQL/Linux? We care about why MySQL appears to be slower, how to improve the situation, and not numbers from poorly done benchmarks which ignored the effect of debugging options, version, disk mount options, etc., which is IMHO meaningless. Maybe a key feature of the new FreeBSD installer would be to automatically tune the user's system (including kernel and other loader/sysctl tunings) according to installed ports :-) To make benchmarks a help provided to improve FreeBSD, a better start would be to run MySQL with profiling options compiled in, to find out the bottleneck and report them (maybe with patches if you have some idea). Cheers, --=20 Xin LI http://www.delphij.net/ See complete headers for GPG key and other information. --0F1p//8PRICkK4MW Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFCwZ6f/cVsHxFZiIoRApykAJ9k+toRW749Bhqoio87KXzrQ8G+6ACfbJQT kP4tO4VK/WFGUhf9S78tOzE= =YsGR -----END PGP SIGNATURE----- --0F1p//8PRICkK4MW--