From owner-freebsd-current@FreeBSD.ORG  Thu Mar 30 06:24:36 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 0249C16A400;
	Thu, 30 Mar 2006 06:24:36 +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 0AD5F43D45;
	Thu, 30 Mar 2006 06:24:35 +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 1FOqf9-000JWZ-RJ; Thu, 30 Mar 2006 15:29:43 +0900
Message-ID: <442B79AE.9000800@micom.mng.net>
Date: Thu, 30 Mar 2006 15:24:46 +0900
From: Ganbold <ganbold@micom.mng.net>
User-Agent: Thunderbird 1.5 (X11/20060202)
MIME-Version: 1.0
To: freebsd-current@freebsd.org
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: 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 06:24:36 -0000

Hi all,

I did make some mysql performance tests under FreeBSD-7.0-CURRENT with 
various
scheduler and compile time options.
It seems like mysql(BUILD_OPTIMIZED=yes, BUILD_STATIC=yes, 
WITH_PROC_SCOPE_PTH=yes)-libpthread-tsc-sched_4bsd+preemption gives
better performance.

The test results are at:

http://www.mnbsd.org/ftp/mysql_test_results.txt

There are several things I didn't test and this leads to some questions:

1. I didn't make test with Poul-Henning's CPU accounting patch. Somehow 
I can't apply it (http://phk.freebsd.dk/patch/cpu_acct_2.patch) cleanly. 
Where can I find latest patch?
When this patch will be included in CURRENT?

2. I didn't make test with Robert Watson's patch 
(http://www.watson.org/~robert/freebsd/clock/)? Does CURRENT src tree 
include it? If not when this patch will be included in CURRENT?

3. I did make tests with default malloc in CURRENT. I'm confused what 
malloc options should try (jemalloc? phkmalloc?) What is the default 
malloc in CURRENT? How to use these different mallocs?

thanks in advance,

Ganbold