From owner-freebsd-hackers@FreeBSD.ORG Wed Nov 10 19:31:07 2004 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BA92316A4CE for ; Wed, 10 Nov 2004 19:31:07 +0000 (GMT) Received: from gundel.de.clara.net (gundel.de.clara.net [212.82.225.86]) by mx1.FreeBSD.org (Postfix) with ESMTP id EB32A43D5C for ; Wed, 10 Nov 2004 19:31:06 +0000 (GMT) (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" 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> 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 cc: freebsd-hackers@freebsd.org cc: Paul Armstrong Subject: Re: Mysql - Linuxthreads : Still needed? X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 10 Nov 2004 19:31:07 -0000 > 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.