From owner-freebsd-threads@FreeBSD.ORG Mon May 24 08:41:46 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 AE46816A4CE for ; Mon, 24 May 2004 08:41:46 -0700 (PDT) Received: from clueful.shagged.org (clueful.shagged.org [212.13.201.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7A71543D3F for ; Mon, 24 May 2004 08:41:46 -0700 (PDT) (envelope-from chris@clueful.shagged.org) Received: from chris by clueful.shagged.org with local (Exim 4.30; FreeBSD) id 1BSHa9-000A9W-Ry; Mon, 24 May 2004 16:41:41 +0100 Date: Mon, 24 May 2004 16:41:41 +0100 From: Chris Elsworth To: Daniel Eischen Message-ID: <20040524154141.GA38874@shagged.org> References: <20040524150321.GA13862@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.6i Sender: Chris Elsworth X-SA-Exim-Mail-From: chris@clueful.shagged.org X-SA-Exim-Scanned: No; SAEximRunCond expanded to false cc: freebsd-threads@freebsd.org 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 15:41:46 -0000 On Mon, May 24, 2004 at 11:29:35AM -0400, Daniel Eischen wrote: > On Mon, 24 May 2004, Chris Elsworth wrote: > > In otherwords you see very little gain when switching from MyISAM > to InnoDB tables in (native) Linux. Yeah, pretty much. The extra couple of hundred on InnoDB are probably InnoDBs superior locking abilities, but any real gain it provides are nulled by the extra logging it has to do. Either way, not a 50% gain. > Any chance of doing the same on FreeBSD? Not on this Xeon I'm afraid, I'm out of testing time and it's being taken to a datacentre on Wednesday for live use. However, we are looking at purchasing an Opteron with an approximate spend of £3500UKP, and I'm perfectly happy to devote a few weeks of testing time on that before it starts doing anything useful. > Where is super-smack? Is it a port? It's not a port - http://jeremy.zawodny.com/mysql/super-smack/ -- Chris