From owner-freebsd-threads@FreeBSD.ORG Fri Oct 22 19:24:14 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 6D95416A4CE for ; Fri, 22 Oct 2004 19:24:14 +0000 (GMT) Received: from silver.he.iki.fi (helenius.fi [193.64.42.241]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5313243D5D for ; Fri, 22 Oct 2004 19:24:13 +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 i9MJO6Um062662; Fri, 22 Oct 2004 22:24:11 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <41795E56.60603@he.iki.fi> Date: Fri, 22 Oct 2004 22:24:06 +0300 From: Petri Helenius 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: Mike Makonnen References: <000901c4b7b4$2113ab70$45fea8c0@turbofresse> <41782BDF.8040301@he.iki.fi> <20041022152103.GA4743@rogue.acs.lan> In-Reply-To: <20041022152103.GA4743@rogue.acs.lan> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: jesk 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 22 Oct 2004 19:24:14 -0000 Mike Makonnen wrote: >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. > > Yes. I meant to ask why system scope threads are faster than process scope threads. They should be the other way around. Pete