From owner-freebsd-amd64@FreeBSD.ORG Wed Jun 16 09:06:09 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1DC3716A4CE for ; Wed, 16 Jun 2004 09:06:09 +0000 (GMT) Received: from TRANG.nuxi.com (trang.nuxi.com [66.93.134.19]) by mx1.FreeBSD.org (Postfix) with ESMTP id D445943D41 for ; Wed, 16 Jun 2004 09:06:08 +0000 (GMT) (envelope-from obrien@NUXI.com) Received: from dragon.nuxi.com (obrien@localhost [127.0.0.1]) by TRANG.nuxi.com (8.12.11/8.12.10) with ESMTP id i5G8sZHL047536; Wed, 16 Jun 2004 01:54:36 -0700 (PDT) (envelope-from obrien@dragon.nuxi.com) Received: (from obrien@localhost) by dragon.nuxi.com (8.12.11/8.12.11/Submit) id i5G8sZVe047535; Wed, 16 Jun 2004 01:54:35 -0700 (PDT) (envelope-from obrien) Date: Wed, 16 Jun 2004 01:54:35 -0700 From: "David O'Brien" To: JG Message-ID: <20040616085435.GA46538@dragon.nuxi.com> References: <5.2.0.9.2.20040614175419.0162dd00@127.0.0.1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5.2.0.9.2.20040614175419.0162dd00@127.0.0.1> User-Agent: Mutt/1.4.1i X-Operating-System: FreeBSD 5.2-CURRENT Organization: The NUXI BSD Group X-Pgp-Rsa-Fingerprint: B7 4D 3E E9 11 39 5F A3 90 76 5D 69 58 D9 98 7A X-Pgp-Rsa-Keyid: 1024/34F9F9D5 cc: freebsd-amd64@freebsd.org Subject: Re: recent -CURRENT changes were very bad for MySQL... X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: freebsd-amd64@freebsd.org List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 16 Jun 2004 09:06:09 -0000 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)