From owner-freebsd-threads@FreeBSD.ORG Mon May 24 08:57:41 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 9F58E16A4CE for ; Mon, 24 May 2004 08:57:41 -0700 (PDT) Received: from clueful.shagged.org (clueful.shagged.org [212.13.201.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id 47D2443D2D for ; Mon, 24 May 2004 08:57:34 -0700 (PDT) (envelope-from chris@clueful.shagged.org) Received: from chris by clueful.shagged.org with local (Exim 4.30; FreeBSD) id 1BSHp3-000AIA-Nd; Mon, 24 May 2004 16:57:05 +0100 Date: Mon, 24 May 2004 16:57:05 +0100 From: Chris Elsworth To: Daniel Eischen Message-ID: <20040524155705.GA39441@shagged.org> References: <20040524143615.GA12869@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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:57:41 -0000 On Mon, May 24, 2004 at 11:51:27AM -0400, Daniel Eischen wrote: > On Mon, 24 May 2004, Chris Elsworth wrote: > > > > So, each of the smackfiles used below was changed to have sql_no_cache > > in the select. The _i smackfile simply has type=innodb in the create > > table statement. > > I'm not a DB person; can you post a diff to the smackfile? root@cluestick:~/super-smack-1.2/smacks# diff select-key.smack_orig select-key_i.smack 23c23 < )"; --- > ) type=innodb"; 50c50 < query "select * from http_auth where username = '$word'"; --- > query "select sql_no_cache * from http_auth where username = '$word'"; And: root@cluestick:~/super-smack-1.2/smacks# diff update-select.smack_orig update-select_i.smack 23c23 < )"; --- > ) type=innodb"; 47c47 < query "select * from http_auth where username = '$word'"; --- > query "select sql_no_cache * from http_auth where username = '$word'"; -- Chris