From owner-freebsd-current@FreeBSD.ORG Tue Oct 16 11:43:30 2007 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id DB5B816A41B for ; Tue, 16 Oct 2007 11:43:30 +0000 (UTC) (envelope-from jdc@parodius.com) Received: from mx01.sc1.parodius.com (mx01.sc1.parodius.com [72.20.106.3]) by mx1.freebsd.org (Postfix) with ESMTP id E732113C494 for ; Tue, 16 Oct 2007 11:43:30 +0000 (UTC) (envelope-from jdc@parodius.com) Received: by mx01.sc1.parodius.com (Postfix, from userid 1000) id 440F71CC065; Tue, 16 Oct 2007 04:43:23 -0700 (PDT) Date: Tue, 16 Oct 2007 04:43:23 -0700 From: Jeremy Chadwick To: Peter Schuller Message-ID: <20071016114323.GA36300@eos.sc1.parodius.com> Mail-Followup-To: Peter Schuller , freebsd-current@freebsd.org References: <20071016110642.GB54457@hyperion.scode.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.16 (2007-06-09) Cc: freebsd-current@freebsd.org Subject: Re: Status of MySQL on 7 w/o patches applied X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Oct 2007 11:43:30 -0000 On Tue, Oct 16, 2007 at 01:40:31PM +0200, Ivan Voras wrote: > Peter Schuller wrote: > > I ask because I recently (a couple of weeks ago) did comparisons using > > sysbench (comparable to what was used in the benchmark used previously > > in the report) between 6.2 and 7-CURRENT. Selects were actually half > > as fast or less than 6.2 in this particular case (identical hardware). > > Just in case you missed some debugging knobs: can you retest with > RELENG_7? (not -current). Also for Peter: can you try different schedulers? The stock RELENG_7 scheduler is 4BSD (reliable but not that fast), while ULE provides an *immense* improvement. The benchmarks I've seen (comparing old vs. new) in regards to MySQL were specifically in regards to the new ULE scheduler. The ULE scheduler in RELENG_7 is not the same as it was in RELENG_6. You'll need to rebuild your kernel for this. You can use the GENERIC kernel template and simply change SCHED_4BSD to SCHED_ULE. -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |