From owner-freebsd-current@FreeBSD.ORG  Tue Nov  1 10:40:00 2005
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
X-Original-To: current@freebsd.org
Delivered-To: freebsd-current@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 213D816A41F
	for <current@freebsd.org>; Tue,  1 Nov 2005 10:40:00 +0000 (GMT)
	(envelope-from chrcoluk@gmail.com)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 6B62343D4C
	for <current@freebsd.org>; Tue,  1 Nov 2005 10:39:59 +0000 (GMT)
	(envelope-from chrcoluk@gmail.com)
Received: by wproxy.gmail.com with SMTP id 71so544722wra
	for <current@freebsd.org>; Tue, 01 Nov 2005 02:39:58 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=lR1F9QJfDT4G6iWfmXGDav70GTKdXqnWunm5xPYe+WsfWlkYzoWo7WnOkslmhGIbIS2KKoqwIwNsfXS0QQA13n4hl0FRWWBuHm5X/Nkw82XFXQcJuOzqtw4jiipkaUMWArpbfOTtzm9/qdvWqrtSWFaX75UOPqsbi86UpUv85dM=
Received: by 10.54.117.16 with SMTP id p16mr1339105wrc;
	Tue, 01 Nov 2005 02:39:58 -0800 (PST)
Received: by 10.54.113.17 with HTTP; Tue, 1 Nov 2005 02:39:58 -0800 (PST)
Message-ID: <3aaaa3a0511010239o2777743dh@mail.gmail.com>
Date: Tue, 1 Nov 2005 10:39:58 +0000
From: Chris <chrcoluk@gmail.com>
To: Michael VInce <mv@roq.com>
In-Reply-To: <4361EE53.80603@roq.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <435F48DA.6060009@kernel32.de>
	<20051026105411.L32255@fledge.watson.org>
	<435F6B01.5020003@kernel32.de> <4361DDBB.4060903@roq.com>
	<4361EE53.80603@roq.com>
Cc: current@freebsd.org, Marian Hettwer <MH@kernel32.de>
Subject: Re: MySQL Performance 6.0rc1
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>, 
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 01 Nov 2005 10:40:00 -0000

Interesting thread I ran super-smack on my production server.

It is an amd64 but using i386 kernel 32bit binaries mysql is optimised
fairly well, mysql 4.0.x compiled with static but not optimised. in
make.conf -O2.  I am using libpthread I believe the new threading
library introduced to 5.x, os is Freebsd 5.4.

super-smack-1.2 # super-smack /usr/share/smacks/select-key.smack 10 10000
Query Barrel Report for client smacker1
connect: max=3D45ms  min=3D0ms avg=3D 31ms from 10 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    200000  0       0       29222.26

so I had a high average ms but my queries per second is impressive
seeing as what has been posted, also bear in mind this box is under
load since it is a production web server, I have a high cache hit
efficiency like I said I optimised it.  It is probable the default's
are just more suited for linux but I think once tweaked it works just
as well on bsd.

Chris