FreeBSD5.3-RC1 MySQL Performance

[Petri Helenius]

Mike Makonnen wrote:

>On Fri, Oct 22, 2004 at 12:36:31AM +0300, Petri Helenius wrote:
>  
>
>>jesk wrote:
>>
>>    
>>
>>>the benchmark is executing 1000 sql-select queries*10 concurrent clients on
>>>a 90k row table with a random not really high cacheable where-statement on
>>>the index:
>>>----
>>>15985 queries per second
>>>(pthreads without process scope threads, sched_4bsd and preemption)
>>>6139   queries per second
>>>(pthreads with process scope threads, sched_4bsd and preemption)
>>>10779 queries per second
>>>(linuxthreads, sched_4bsd and preemption)
>>>fedora result:
>>>11900 queries per second
>>>----
>>>
>>>
>>>maybe someone got some hints for improvement of this situation...
>>>
>>>
>>>      
>>>
>>Do you have any idea why process scope threads are faster than system 
>>scope threads? My gut feeling is that it should be exactly opposite.
>>    
>>
>
>I think you're reading it wrong: 'pthreads without process scope threads'
>					   ^^^^^^^
>gets 15985 qps whereas 'with process scope threads' it only gets 6139 qps.
>  
>
Yes. I meant to ask why system scope threads are faster than process 
scope threads. They should be the other way around.

Pete