Date: Mon, 24 May 2004 16:57:05 +0100 From: Chris Elsworth <chris@shagged.org> To: Daniel Eischen <eischen@vigrid.com> Cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? Message-ID: <20040524155705.GA39441@shagged.org> In-Reply-To: <Pine.GSO.4.10.10405241150110.28214-100000@pcnet5.pcnet.com> References: <20040524143615.GA12869@shagged.org> <Pine.GSO.4.10.10405241150110.28214-100000@pcnet5.pcnet.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040524155705.GA39441>