From owner-freebsd-threads@FreeBSD.ORG  Tue Nov 13 01:23:49 2007
Return-Path: <owner-freebsd-threads@FreeBSD.ORG>
Delivered-To: freebsd-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 D483B16A419;
	Tue, 13 Nov 2007 01:23:49 +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 C291313C4BC;
	Tue, 13 Nov 2007 01:23:49 +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 lAD1Ni4n039156;
	Tue, 13 Nov 2007 01:23:46 GMT (envelope-from davidxu@freebsd.org)
Message-ID: <4738FCD8.4010907@freebsd.org>
Date: Tue, 13 Nov 2007 09:24:40 +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: Jeff Roberson <jroberson@chesapeake.net>
References: <4727E907.4090308@freebsd.org>
	<499c70c0710310217k3e55b66en23d32c2f6a613c99@mail.gmail.com>
	<fg9u5h$ume$1@ger.gmane.org> <472927B2.2090102@freebsd.org>
	<20071112124354.H639@10.0.0.1>
In-Reply-To: <20071112124354.H639@10.0.0.1>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Ivan Voras <ivoras@FreeBSD.org>, freebsd-threads@FreeBSD.org
Subject: Re: PTHREAD_YIELDLOOPS boosts mysql super-smack performance
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: Tue, 13 Nov 2007 01:23:49 -0000

Jeff Roberson wrote:
> On Thu, 1 Nov 2007, David Xu wrote:
> 
>> Ivan Voras wrote:
>>
>>> Abdullah Ibn Hamad Al-Marri wrote:
>>>
>>>> On Oct 31, 2007 5:31 AM, David Xu <davidxu@freebsd.org> wrote:
>>>
>>>
>>>
>>>>> it seems over 44% performance is improved.
>>>
>>>
>>>
>>>> When could you please commit these changes of libthr will hit RELENG_7
>>>> so we could benefit of these improvements?
>>>
>>>
>>>
>>> I agree this would be very nice to have in 7.0, especially since it's
>>> off by default. We can add a tagline to the release to the tune of
>>> "MySQL gets smacked!"
>>>
>>
>> I will request a MFC. :-)
> 
> 
> Did you try recompiling mysql to pickup chris's ADAPTIVE_MUTEX_NP 
> changes? How does this compare?
> 
>>
>> Regards,

Yes, I had recompiled it, but I hadn't found any performance change
with ADAPTIVE_MUTEX_NP :-)

Regards,
David Xu