FreeBSD5.3-RC1 MySQL Performance

Petri Helenius pete at he.iki.fi
Thu Oct 21 14:36:39 PDT 2004


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.

Pete



More information about the freebsd-threads mailing list