Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 10 Nov 2004 12:12:44 -0800
From:      Julian Elischer <julian@elischer.org>
To:        threads@freebsd.org
Subject:   [Fwd: Re: Mysql - Linuxthreads : Still needed?]
Message-ID:  <4192763C.2010403@elischer.org>

next in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format.
--------------050009020300010407000300
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

send to the right list.


--------------050009020300010407000300
Content-Type: message/rfc822;
 name="Re: Mysql - Linuxthreads : Still needed?"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline;
 filename="Re: Mysql - Linuxthreads : Still needed?"

Received: from gundel.de.clara.net (gundel.de.clara.net [212.82.225.86])
	by idiom.com (8.12.11/8.12.11) with ESMTP id iAAJV7K8020167
	for <julian@elischer.org>; Wed, 10 Nov 2004 11:31:09 -0800 (PST)
	(envelope-from jesk@killall.org)
Received: from port-212-202-52-250.dynamic.qsc.de ([212.202.52.250]
	helo=turbofresse)
	by gundel.de.clara.net with smtp (Exim 4.30; FreeBSD)
	id 1CRyNx-000GDa-78; Wed, 10 Nov 2004 20:44:05 +0100
Message-ID: <004301c4c75b$d123eb40$45fea8c0@turbofresse>
From: "jesk" <jesk@killall.org>
To: "Julian Elischer" <julian@elischer.org>
Cc: <freebsd-hackers@freebsd.org>, "Paul Armstrong" <freebsdhackers@otoh.org>
References:
	<1099935987.4899.1730.camel@work.gusalmighty.com><200411081334.18009.jhb@FreeBSD.org><1099940205.4899.1733.camel@work.gusalmighty.com><20041108191351.370c2d5d.thib@mi.is><B4CC5D73A1357576BB486258@jesk.int.de.clara.net><Pine.OSX.4.61.0411091157420.587@oof.local><001701c4c69e$1e81c510$45fea8c0@turbofresse><20041109211358.GE78631@suricate.otoh.org><000901c4c6f2$db56a350$45fea8c0@turbofresse>
	<4191CE51.1030804@elischer.org><421DCC530ABF5A3AA0E89732@jesk.int.de.clara.net><31801D182841B7CFCFAC70A3@jesk.int.de.clara.net>
	<41923820.6060903@elischer.org>
Subject: Re: Mysql - Linuxthreads : Still needed?
Date: Wed, 10 Nov 2004 20:31:03 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Accessio-Status: NO, score=0.00,none version=6.0 count=0
X-Accessio-Spam-Flag: NO
X-Spam-Checker-Version: SpamAssassin 3.0.1 (2004-10-22) on mx.idiom.com
X-Spam-Status: No, score=0.0 required=5.0 tests=none autolearn=failed 
	version=3.0.1
X-Idiom-Reporting: If this was spam, please report it to spamcop.net

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

--------------050009020300010407000300--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4192763C.2010403>