From owner-freebsd-threads@FreeBSD.ORG Wed Nov 10 20:12:47 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D221716A4CE for ; Wed, 10 Nov 2004 20:12:47 +0000 (GMT) Received: from mail.vicor-nb.com (bigwoop.vicor-nb.com [208.206.78.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3A11643D4C for ; Wed, 10 Nov 2004 20:12:47 +0000 (GMT) (envelope-from julian@elischer.org) Received: from elischer.org (julian.vicor-nb.com [208.206.78.97]) by mail.vicor-nb.com (Postfix) with ESMTP id 6A1097A427 for ; Wed, 10 Nov 2004 12:12:45 -0800 (PST) Message-ID: <4192763C.2010403@elischer.org> Date: Wed, 10 Nov 2004 12:12:44 -0800 From: Julian Elischer User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3.1) Gecko/20030516 X-Accept-Language: en, hu MIME-Version: 1.0 To: threads@freebsd.org Content-Type: multipart/mixed; boundary="------------050009020300010407000300" Subject: [Fwd: Re: Mysql - Linuxthreads : Still needed?] X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 10 Nov 2004 20:12:48 -0000 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 ; 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" To: "Julian Elischer" Cc: , "Paul Armstrong" 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><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--