From owner-freebsd-threads@FreeBSD.ORG  Thu Oct 21 21:36:39 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 3294E16A4CE
	for <threads@freebsd.org>; Thu, 21 Oct 2004 21:36:39 +0000 (GMT)
Received: from silver.he.iki.fi (helenius.fi [193.64.42.241])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B131D43D45
	for <threads@freebsd.org>; Thu, 21 Oct 2004 21:36:37 +0000 (GMT)
	(envelope-from pete@he.iki.fi)
Received: from [193.64.42.134] (h86.vuokselantie10.fi [193.64.42.134])
	by silver.he.iki.fi (8.13.1/8.11.4) with ESMTP id i9LLaTJl026318;
	Fri, 22 Oct 2004 00:36:29 +0300 (EEST)
	(envelope-from pete@he.iki.fi)
Message-ID: <41782BDF.8040301@he.iki.fi>
Date: Fri, 22 Oct 2004 00:36:31 +0300
From: Petri Helenius <pete@he.iki.fi>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.7.2) Gecko/20040803
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: jesk <jesk@killall.org>
References: <000901c4b7b4$2113ab70$45fea8c0@turbofresse>
In-Reply-To: <000901c4b7b4$2113ab70$45fea8c0@turbofresse>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
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: Thu, 21 Oct 2004 21:36:39 -0000

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.

Pete