FreeBSD5.3-RC1 MySQL Performance

[Julian Elischer]

Petri Helenius wrote:

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


It's one of these things where the two schemes are so different that 
they have WAY different
performance characteristics for any given task.
Peter had a test where process scope threads ran 50(!) times faster 
(than system scope)
yet in some tests it runs slower..

We need to tune a lot but we've been concentrating on
just making it work..

>
>
> Pete
>
> _______________________________________________
> freebsd-threads at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-threads
> To unsubscribe, send any mail to 
> "freebsd-threads-unsubscribe at freebsd.org"