From owner-freebsd-threads@FreeBSD.ORG Mon May 24 09:10:18 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EA4A116A4CE for ; Mon, 24 May 2004 09:10:18 -0700 (PDT) Received: from mta07-svc.ntlworld.com (mta07-svc.ntlworld.com [62.253.162.47]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4664F43D2D for ; Mon, 24 May 2004 09:10:18 -0700 (PDT) (envelope-from tom.hurst@clara.net) Received: from voi.aagh.net ([81.104.55.176]) by mta07-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040524161024.JUKB5696.mta07-svc.ntlworld.com@voi.aagh.net> for ; Mon, 24 May 2004 17:10:24 +0100 Received: from freaky by voi.aagh.net with local (Exim 4.34; FreeBSD) id 1BSI1k-0000mV-2l for freebsd-threads@freebsd.org; Mon, 24 May 2004 17:10:12 +0100 Date: Mon, 24 May 2004 17:10:12 +0100 From: Thomas Hurst To: freebsd-threads@freebsd.org Message-ID: <20040524161012.GA2498@voi.aagh.net> Mail-Followup-To: freebsd-threads@freebsd.org References: <5.2.0.9.2.20040523200223.01583468@mail.ojoink.com> <5.2.0.9.2.20040523103738.01563ed0@mail.ojoink.com> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040523103738.01563ed0@mail.ojoink.com> <5.2.0.9.2.20040523200223.01583468@mail.ojoink.com> <5.2.0.9.2.20040524081943.0343ec68@mail.ojoink.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5.2.0.9.2.20040524081943.0343ec68@mail.ojoink.com> Organization: Not much. User-Agent: Mutt/1.5.6i Sender: Thomas Hurst Subject: Re: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 24 May 2004 16:10:19 -0000 * JG (amd64list@jpgsworld.com) wrote: > At 03:45 PM 5/24/2004 +0100, you wrote: > > Still, if we're going to be comparing with results from Linux which > > are near the peak of it's performance curve we don't want to be > > running in the middle of our much lower one. > > Why would you assume Linux is near the peak of it's performance curve? I don't mean generally (the curve of super-smack results across various tunings); I mean the curve you plot with a single set of tunings as you increase the number of clients; performance peaks around $numcpu clients and then drops off as you increase load -- the values being quoted for Linux seem to be around $numcpu level clients. IIRC (heh, pinch of salt time ;) at 30 clients Linux got about 55-65% the performance it got at 4 (numcpu for a HTT dual Xeon), but don't take my word for it (I'll check later if necessary, although without similar hardware to compare against I doubt it's going to be very helpful). > Nobody that I have seen so far, including myself, has even tried to tweak > Linux or MySQL on Linux beyond and out-of-the-box installation to get > results that far exceed the performance of FreeBSD. I think the most we did was use my-huge.cnf, which is the bundled config suggested for >1GB systems. You're right that there's not a lot of need to tune to get damn good results on Linux though; at least on this relatively small benchmark. > Yeah I'm sorry I flamed you there... I'm just very frustrated over here. After recompiling MySQL about 20 times in a row, I fully understand :/ -- Thomas 'Freaky' Hurst - freaky@aagh.net - http://www.aagh.net/