Date: Fri, 22 Oct 2004 18:21:03 +0300 From: Mike Makonnen <mtm@identd.net> To: Petri Helenius <pete@he.iki.fi> Cc: threads@freebsd.org Subject: Re: FreeBSD5.3-RC1 MySQL Performance Message-ID: <20041022152103.GA4743@rogue.acs.lan> In-Reply-To: <41782BDF.8040301@he.iki.fi> References: <000901c4b7b4$2113ab70$45fea8c0@turbofresse> <41782BDF.8040301@he.iki.fi>
next in thread | previous in thread | raw e-mail | index | archive | help
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 !
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20041022152103.GA4743>