From owner-freebsd-threads@FreeBSD.ORG  Mon May 24 08:29:56 2004
Return-Path: <owner-freebsd-threads@FreeBSD.ORG>
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 97FC816A4CE
	for <freebsd-threads@freebsd.org>;
	Mon, 24 May 2004 08:29:56 -0700 (PDT)
Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3C3B543D48
	for <freebsd-threads@freebsd.org>;
	Mon, 24 May 2004 08:29:54 -0700 (PDT)
	(envelope-from eischen@vigrid.com)
Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4])
	by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i4OFTZ8Q024668;
	Mon, 24 May 2004 11:29:35 -0400 (EDT)
Date: Mon, 24 May 2004 11:29:35 -0400 (EDT)
From: Daniel Eischen <eischen@vigrid.com>
X-Sender: eischen@pcnet5.pcnet.com
To: Chris Elsworth <chris@shagged.org>
In-Reply-To: <20040524150321.GA13862@shagged.org>
Message-ID: <Pine.GSO.4.10.10405241125120.20147-100000@pcnet5.pcnet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
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 <freebsd-threads.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-threads>
List-Post: <mailto:freebsd-threads@freebsd.org>
List-Help: <mailto:freebsd-threads-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 24 May 2004 15:29:56 -0000

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