PTHREAD_YIELDLOOPS boosts mysql super-smack performance

[David Xu]

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 at 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