From owner-freebsd-performance@FreeBSD.ORG  Mon Jul  3 06:17:51 2006
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by hub.freebsd.org (Postfix) with ESMTP id 7C51B16A403;
	Mon,  3 Jul 2006 06:17:50 +0000 (UTC)
	(envelope-from davidxu@freebsd.org)
Message-ID: <44A8B68F.5060802@freebsd.org>
Date: Mon, 03 Jul 2006 14:17:51 +0800
From: David Xu <davidxu@freebsd.org>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.12) Gecko/20060519
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Hugo Silva <hugo@barafranca.com>
References: <44A894B0.3010506@barafranca.com>
In-Reply-To: <44A894B0.3010506@barafranca.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-performance@freebsd.org
Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 03 Jul 2006 06:17:51 -0000

Hugo Silva wrote:
> 
> Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE.
> This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks that 
> do 320MB/s
> 
> For all the tests, I restarted mysqld prior to starting the test,  
> waited for about 1 minute for it to settle down, and ran super smack. 
> For the consecutive runs, I executed super-smack right after the 
> previous run ended.
> 
> Switching from HTT to no HTT was achieved by 
> machdep.hyperthreading_allowed, and switching from/to libpthread/libthr 
> was done via libmap.conf.
> 
> System:
> 
> FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul  3 03:10:35 UTC 
> 2006     ??@??:/usr/obj/usr/src/sys/DATABASE  i386
> 
> Here are the results:
> 
> 
> MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes
> 
> 

Please don't run mysql in PROC_SCOPE with libthr, it has no benefit and
can only hurt performance, you can forcely turn it off by:

sysctl kern.threads.thr_scope=2

the proc scope support may be dropped near future in libthr, thanks for 
your evaluation.

David Xu