From owner-freebsd-stable@FreeBSD.ORG Tue Jun 28 16:39:30 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 27A5B16A464 for ; Tue, 28 Jun 2005 16:39:30 +0000 (GMT) (envelope-from neuhauser@sigpipe.cz) Received: from isis.sigpipe.cz (fw.sigpipe.cz [62.245.70.224]) by mx1.FreeBSD.org (Postfix) with ESMTP id CCFE443D49 for ; Tue, 28 Jun 2005 16:39:29 +0000 (GMT) (envelope-from neuhauser@sigpipe.cz) Received: by isis.sigpipe.cz (Postfix, from userid 1001) id 3875D1F87BEE; Tue, 28 Jun 2005 18:39:28 +0200 (CEST) Date: Tue, 28 Jun 2005 18:39:28 +0200 From: Roman Neuhauser To: Paul Mather Message-ID: <20050628163928.GA51923@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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1119973124.7900.20.camel@zappa.Chelsea-Ct.Org> User-Agent: Mutt/1.5.9i 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 16:39:30 -0000 # paul@gromit.dlib.vt.edu / 2005-06-28 11:38:44 -0400: > Note how the transfer rate for the "outside" is almost twice that of the > "inside." Suppose I run tests on two different operating systems, one > of which resides in a partition on the "inside" portion and the other in > one on the "outside" portion. Which is not the case according to the OP... > (Note that however good or bad it may be, the "location selection > strategy in the driver" can only lay out data within the confines of > the partition.) Now, I do a "dd" test and find that the "outside" OS > is almost twice as fast as the other. Would it be wise to conclude > that the slower OS is woefully inefficient compared to the faster one? > Suppose both tests turn out to take roughly the same time. Should I > conclude that the OS residing on the "inside" is just as efficient as > the other OS? ... rendering this completely irrelevant. I have seen people come to a freebsd list with completely flawed comparisons or benchmarks: OSs installed on different partitions side by side, not taking VM cache into account, whatever, and be told that their numbers are flawed. I have also seen people test a specific subsystem (dd), and be told that their numbers don't reflect real world. And I have seen people test real world performance (install FreeBSD, install MySQL, run a stress test, reformat, install Linux, install MySQL, run a stress test) and get responses that try to make up reasons why the bad results are the testers fault). Heck, if installing an operating system, a database, and running it isn't a real world test, I don't know what is. Even if the bug is "FreeBSD puts /var/db/mysql in the wrong part of the disk" (then it's still a problem in FreeBSD, not in the messenger). I just wish people here were less defensive, that's all. -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991