From owner-freebsd-current@FreeBSD.ORG  Thu Mar 30 09:28:17 2006
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
X-Original-To: freebsd-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 E948E16A401;
	Thu, 30 Mar 2006 09:28:16 +0000 (UTC)
	(envelope-from ganbold@micom.mng.net)
Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C707A43D46;
	Thu, 30 Mar 2006 09:28:15 +0000 (GMT)
	(envelope-from ganbold@micom.mng.net)
Received: from [202.179.0.164] (helo=[192.168.0.18])
	by publicd.ub.mng.net with esmtpa (Exim 4.60 (FreeBSD))
	(envelope-from <ganbold@micom.mng.net>)
	id 1FOtWu-000MdQ-D3; Thu, 30 Mar 2006 18:33:24 +0900
Message-ID: <442BA4BB.1050306@micom.mng.net>
Date: Thu, 30 Mar 2006 18:28:27 +0900
From: Ganbold <ganbold@micom.mng.net>
User-Agent: Thunderbird 1.5 (X11/20060202)
MIME-Version: 1.0
To: freebsd-current@freebsd.org
References: <07018E951F2FBF42B40B3D61086788344C1D9D@ednex511.dsto.defence.gov.au>
In-Reply-To: <07018E951F2FBF42B40B3D61086788344C1D9D@ednex511.dsto.defence.gov.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: jasone@freebsd.org, deischen@freebsd.org, phk@phk.freebsd.dk,
	rwatson@FreeBSD.org, davidxu@freebsd.org, grog@freebsd.org
Subject: Re: mysql performance test results under FreeBSD-7.0-CURRENT
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: Thu, 30 Mar 2006 09:28:17 -0000

I added some more test results (without WITNESS, INVARIANTS options in 
kernel).
For example:

55. mysql(BUILD_OPTIMIZED=yes, BUILD_STATIC=yes, 
WITH_PROC_SCOPE_PTH=yes)-libpthread-acpifast-sched_4bsd+preemption
select_index    20000   1       0       8774.85
select_index    20000   1       0       8516.60
select_index    20000   0       0       8670.70
select_index    20000   1       0       8645.69
select_index    20000   1       0       8581.23
select_index    10000   2       0       1469.15
select_index    10000   5       0       1428.56
select_index    10000   2       0       1466.94
select_index    10000   5       0       1465.94
select_index    10000   3       0       1488.45

56. mysql(BUILD_OPTIMIZED=yes, BUILD_STATIC=yes, 
WITH_PROC_SCOPE_PTH=yes)-libpthread-tsc-sched_4bsd+preemption
select_index    20000   0       0       9192.43
select_index    20000   1       0       8937.86
select_index    20000   0       0       9017.22
select_index    20000   0       0       9227.45
select_index    20000   1       0       9332.93
select_index    10000   3       0       1498.85
select_index    10000   2       0       1508.35
select_index    10000   3       0       1495.36
select_index    10000   3       0       1402.65
select_index    10000   3       0       1508.09

More results are at: http://www.mnbsd.org/ftp/mysql_test_results.txt

Ganbold