Mysql - Linuxthreads : Still needed?

jesk jesk at killall.org
Wed Nov 10 11:31:07 PST 2004


> now I'm completely confused..
> can you give a summary again:-)

ok here it is:
 -----------------
around 16000 queries per second
(pthreads without process scope threads, sched_4bsd and preemption)
around 7000   queries per second
(pthreads with process scope threads, sched_4bsd and preemption)
around 16000 queries per second
(linuxthreads, sched_4bsd and preemption)
fedora result:
11900 queries per second
----
same test (same parameters) but with a update query first and then a select
query on the same key i realized worse values for freebsd:
----
around 2500 queries per second
(pthreads without process scope threads, sched_4bsd and preemption)
around 2000 queries per second
(pthreads with process scope threads, sched_4bsd and preemption)
around 4000 queries per second
(linuxthreads, sched_4bsd and preemption)
fedora result:
3920.21 queries per second´
-----------------

Because of the missing hardware i couldnt run the test again and so the
result above isnt 100% true. But the guesses should reflect the ratio of the
used engines in my test.



More information about the freebsd-hackers mailing list