Date: Mon, 24 May 2004 11:29:35 -0400 (EDT) From: Daniel Eischen <eischen@vigrid.com> To: Chris Elsworth <chris@shagged.org> Cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? Message-ID: <Pine.GSO.4.10.10405241125120.20147-100000@pcnet5.pcnet.com> In-Reply-To: <20040524150321.GA13862@shagged.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 24 May 2004, Chris Elsworth wrote:
> Please consider all the InnoDB results just posted as void and
> replaced with the following:
So to summarize in one place:
Run: super-smack-1.2# src/super-smack smacks/select-key.smack 4 100000
DBType Query_type num_queries max_time min_time q_per_s
----------------------------------------------------------------
MyISAM select_index 800000 0 0 22063.58
InnoDB select_index 800000 0 0 22509.05
Run: super-smack-1.2# src/super-smack smacks/update-select_i.smack 4 100000
(innodb_flush_log_at_trx_commit = 0)
DBType Query_type num_queries max_time min_time q_per_s
----------------------------------------------------------------
MyISAM select_index 400000 0 0 8296.32
update_index 400000 0 0 8296.32
InnoDB select_index 400000 0 0 8473.54
update_index 400000 0 0 8473.54
In otherwords you see very little gain when switching from MyISAM
to InnoDB tables in (native) Linux.
Any chance of doing the same on FreeBSD?
Where is super-smack? Is it a port?
--
Dan Eischen
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.GSO.4.10.10405241125120.20147-100000>