Date: Wed, 16 Jun 2004 01:54:35 -0700 From: "David O'Brien" <obrien@freebsd.org> To: JG <amd64list@jpgsworld.com> Cc: freebsd-amd64@freebsd.org Subject: Re: recent -CURRENT changes were very bad for MySQL... Message-ID: <20040616085435.GA46538@dragon.nuxi.com> In-Reply-To: <5.2.0.9.2.20040614175419.0162dd00@127.0.0.1> References: <5.2.0.9.2.20040614175419.0162dd00@127.0.0.1>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Jun 14, 2004 at 06:34:28PM -0700, JG wrote: > amd64f# super-smack update-select.smack 30 10000 > > Query Barrel Report for client smacker > connect: max=46ms min=2ms avg= 26ms from 30 clients > Query_type num_queries max_time min_time q_per_s > select_index 300000 2 0 958.05 > update_index 300000 2 0 958.05 > > In all my previous tests I think that number was at least 2000/qps > (and that was bad) and as much as 4000/qps. > > Whatever was changed recently really killed performance in this area. > > This is a SMP kerenel using SCHED_ULE. Try commenting out the "options ADAPTIVE_MUTEXES" in GENERIC, and let this list know if you see any different.. -- -- David (obrien@FreeBSD.org)
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040616085435.GA46538>