From owner-freebsd-threads@FreeBSD.ORG Fri Oct 22 19:57:40 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 B86A216A4CE for ; Fri, 22 Oct 2004 19:57:40 +0000 (GMT) Received: from mail.vicor-nb.com (bigwoop.vicor-nb.com [208.206.78.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9D6E443D1D for ; Fri, 22 Oct 2004 19:57:40 +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 7AFFB7A425; Fri, 22 Oct 2004 12:57:40 -0700 (PDT) Message-ID: <41796634.1040706@elischer.org> Date: Fri, 22 Oct 2004 12:57:40 -0700 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: Petri Helenius References: <000901c4b7b4$2113ab70$45fea8c0@turbofresse> <41782BDF.8040301@he.iki.fi> <20041022152103.GA4743@rogue.acs.lan> <41795E56.60603@he.iki.fi> In-Reply-To: <41795E56.60603@he.iki.fi> Content-Type: text/plain; charset=ISO-8859-1; 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:57:40 -0000 Petri Helenius wrote: > 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. It's one of these things where the two schemes are so different that they have WAY different performance characteristics for any given task. Peter had a test where process scope threads ran 50(!) times faster (than system scope) yet in some tests it runs slower.. We need to tune a lot but we've been concentrating on just making it work.. > > > Pete > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to > "freebsd-threads-unsubscribe@freebsd.org"