Date: Wed, 29 Jun 2005 03:01:51 +0800 From: Xin LI <delphij@frontfree.net> To: Roman Neuhauser <neuhauser@sigpipe.cz> Cc: freebsd-stable@freebsd.org, Michael Schuh <michael.schuh@gmail.com> Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <20050628190151.GA22060@frontfree.net> In-Reply-To: <20050628171739.GC51923@isis.sigpipe.cz> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
--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 <delphij frontfree net> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050628190151.GA22060>