From owner-freebsd-performance@FreeBSD.ORG Wed Jun 29 21:00:45 2005 Return-Path: X-Original-To: performance@freebsd.org Delivered-To: freebsd-performance@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D7F1916A41C for ; Wed, 29 Jun 2005 21:00:45 +0000 (GMT) (envelope-from nevans@talkpoint.com) Received: from relay.talkpoint.com (relay.talkpoint.com [204.141.15.158]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9684C43D49 for ; Wed, 29 Jun 2005 21:00:45 +0000 (GMT) (envelope-from nevans@talkpoint.com) Received: from ASSP-nospam ([127.0.0.1]) by relay.talkpoint.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 29 Jun 2005 17:00:44 -0400 Received: from 204.141.15.194 ([204.141.15.194] helo=pleiades.nextvenue.com) by ASSP-nospam ; 29 Jun 05 21:00:44 -0000 Date: Wed, 29 Jun 2005 17:00:44 -0400 From: Nick Evans To: Jeremie Le Hen Message-ID: <20050629170044.0ea27b23@pleiades.nextvenue.com> In-Reply-To: <20050629094533.GA49933@obiwan.tataz.chchile.org> References: <20050623145041.GC64879@bibipentium.lonres.com> <42BD64F1.4080001@roq.com> <20050627134146.GA626@bibipentium.lonres.com> <42C1FA31.3050806@roq.com> <20050629094533.GA49933@obiwan.tataz.chchile.org> X-Mailer: Sylpheed-Claws 1.9.11 (GTK+ 2.6.7; i386-portbld-freebsd5.4) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 29 Jun 2005 21:00:44.0572 (UTC) FILETIME=[9DC16DC0:01C57CED] Cc: Michael Vince , Steve Roome , performance@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 29 Jun 2005 21:00:46 -0000 I just tried this on my dual opteron test rig and didn't notice a difference in performance with noatime set. What did make a difference was moving from fxp to bge network cards. bge supports checksum offloading where fxp only supports interrupt bundling. Freed up another 20% idle during my test runs. I'm now hitting ~23,000 selects/sec, ~42% idle when running select-key.smack from 3 client hosts. If we establish a suitable test mix and distribute the smack/data files at least we can get consistent test results across systems. Nick 6-CURRENT as of Jun 27th Dual Opteron 246 Tyan K8SD Thunder Pro 4GB RAM my-huge.cnf with tweaks. On Wed, 29 Jun 2005 11:45:33 +0200 Jeremie Le Hen wrote: > Hi Michael, hi Steve, > > > For me this is as fast as I need my database to be but I can understand > > there is a difference here between FreeBSD and Linux that would make you > > prefer it as the db OS choice. > > Could you try mounting the filesystem where the database lives with > the noatime option, and re-run your tests ? IIRC from previous threads > on this subject, Linux doesn't really honor this while FreeBSD does, > which pulls down the performances. > > Regards, > -- > Jeremie Le Hen > < jeremie at le-hen dot org >< ttz at chchile dot org > > _______________________________________________ > freebsd-performance@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-performance > To unsubscribe, send any mail to "freebsd-performance- > unsubscribe@freebsd.org"