From owner-freebsd-threads@FreeBSD.ORG  Wed Oct 31 05:14:13 2007
Return-Path: <owner-freebsd-threads@FreeBSD.ORG>
Delivered-To: threads@hub.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 107D016A417
	for <threads@hub.freebsd.org>; Wed, 31 Oct 2007 05:14:13 +0000 (UTC)
	(envelope-from davidxu@FreeBSD.org)
Received: from freefall.freebsd.org (freefall.freebsd.org
	[IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id 0407E13C481
	for <threads@hub.freebsd.org>; Wed, 31 Oct 2007 05:14:13 +0000 (UTC)
	(envelope-from davidxu@FreeBSD.org)
Received: from [127.0.0.1] (root@localhost [127.0.0.1])
	by freefall.freebsd.org (8.14.1/8.14.1) with ESMTP id l9V5E9fs010318
	for <threads@freebsd.org>; Wed, 31 Oct 2007 05:14:12 GMT
	(envelope-from davidxu@freebsd.org)
Message-ID: <47280F58.5070507@freebsd.org>
Date: Wed, 31 Oct 2007 13:15:04 +0800
From: David Xu <davidxu@FreeBSD.org>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.13) Gecko/20070516
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: threads@FreeBSD.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Cc: 
Subject: mysql supersmack select benchmark
X-BeenThere: freebsd-threads@freebsd.org
X-Mailman-Version: 2.1.5
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: Wed, 31 Oct 2007 05:14:13 -0000

I did a simple mysql super-smack benchmark test on a Intel XEON machine,
the CPU has 4 cores:
    CPU: Intel(R) Xeon(R) CPU            5130  @ 2.00GHz (1997.03-MHz)


I have set environment variable LIBPTHREAD_YIELDLOOPS to 30 and start 
mysql server:

setenv LIBPTHREAD_YIELDLOOPS 30
/usr/local/etc/rc.d/mysql-server start

and repeat doing
#super-smack ./select-key.smack 10 20000

The result is very surprising:

# /usr/src/tools/tools/ministat/ministat normal.txt yield_30.txt

x normal.txt
+ yield_30.txt
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
|  x  x x                                              +              |
|  x xxxx                                         + + ++              |
|x x xxxxx x                                       + + + ++        + 
           |
|x x xxxxxxx   x      x                +                    + + ++++++ 
++++ +++  ++             +|
|  |___A___|                                    |________M_A_________| 
             |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
     N           Min           Max        Median           Avg        Stddev
x  30      44790.57      48609.38     45831.065     45910.616     745.54679
+  30      60521.95       73090.6     66008.135     66254.815     1953.4324
Difference at 95.0% confidence
         20344.2 ± 764.241
         44.3126% ± 1.66463%
         (Student's t, pooled s = 1478.47)

it seems over 44% performance is improved.

Regards,
David Xu