From owner-freebsd-threads@FreeBSD.ORG  Fri Oct 22 15:42:37 2004
Return-Path: <owner-freebsd-threads@FreeBSD.ORG>
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 A4AC416A4CE
	for <threads@freebsd.org>; Fri, 22 Oct 2004 15:42:37 +0000 (GMT)
Received: from telecom.net.et (sparrow.telecom.net.et [213.55.64.50])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 67A6F43D45
	for <threads@freebsd.org>; Fri, 22 Oct 2004 15:42:32 +0000 (GMT)
	(envelope-from mtm@identd.net)
Received: from [213.55.68.16] (HELO rogue.acs.lan)
  by telecom.net.et (CommuniGate Pro SMTP 3.4.8)
  with ESMTP id 60837848; Fri, 22 Oct 2004 18:14:21 +0300
Received: by rogue.acs.lan (Postfix, from userid 1000)
	id 78704B872; Fri, 22 Oct 2004 18:21:03 +0300 (EAT)
Date: Fri, 22 Oct 2004 18:21:03 +0300
From: Mike Makonnen <mtm@identd.net>
To: Petri Helenius <pete@he.iki.fi>
Message-ID: <20041022152103.GA4743@rogue.acs.lan>
References: <000901c4b7b4$2113ab70$45fea8c0@turbofresse>
	<41782BDF.8040301@he.iki.fi>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <41782BDF.8040301@he.iki.fi>
User-Agent: Mutt/1.4.2.1i
X-Operating-System: FreeBSD/6.0-CURRENT (i386)
cc: jesk <jesk@killall.org>
cc: threads@freebsd.org
Subject: Re: FreeBSD5.3-RC1 MySQL Performance
X-BeenThere: freebsd-threads@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Threading on FreeBSD <freebsd-threads.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-threads>
List-Post: <mailto:freebsd-threads@freebsd.org>
List-Help: <mailto:freebsd-threads-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 22 Oct 2004 15:42:37 -0000

On Fri, Oct 22, 2004 at 12:36:31AM +0300, Petri Helenius wrote:
> 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.

I think you're reading it wrong: 'pthreads without process scope threads'
					   ^^^^^^^
gets 15985 qps whereas 'with process scope threads' it only gets 6139 qps.

Cheers.
-- 
Mike Makonnen  | GPG-KEY: http://www.identd.net/~mtm/mtm.asc
mtm@identd.net | Fingerprint: AC7B 5672 2D11 F4D0 EBF8  5279 5359 2B82 7CD4 1F55
mtm@FreeBSD.Org| FreeBSD - Unleash the Daemon !