From owner-freebsd-performance@FreeBSD.ORG Sat Dec 17 00:21:58 2005 Return-Path: X-Original-To: freebsd-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 C361D16A41F for ; Sat, 17 Dec 2005 00:21:58 +0000 (GMT) (envelope-from scottl@samsco.org) Received: from pooker.samsco.org (pooker.samsco.org [168.103.85.57]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6618543D69 for ; Sat, 17 Dec 2005 00:21:52 +0000 (GMT) (envelope-from scottl@samsco.org) Received: from [192.168.254.14] (imini.samsco.home [192.168.254.14]) (authenticated bits=0) by pooker.samsco.org (8.13.4/8.13.4) with ESMTP id jBH0LowO021524; Fri, 16 Dec 2005 17:21:51 -0700 (MST) (envelope-from scottl@samsco.org) Message-ID: <43A35A1E.3020408@samsco.org> Date: Fri, 16 Dec 2005 17:21:50 -0700 From: Scott Long User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.7) Gecko/20050416 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Gea-Suan Lin References: <20051216064615.GA41775@gslin.org> <20051216070609.GA3216@il.fontys.nl> <20051216204322.GA66409@gslin.org> In-Reply-To: <20051216204322.GA66409@gslin.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, score=-1.4 required=3.8 tests=ALL_TRUSTED autolearn=failed version=3.1.0 X-Spam-Checker-Version: SpamAssassin 3.1.0 (2005-09-13) on pooker.samsco.org Cc: freebsd-performance@freebsd.org, leo.huang.gd@gmail.com, Rink Springer Subject: Re: Benchmark MySQL Performance On FreeBSD And 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: Sat, 17 Dec 2005 00:21:58 -0000 Gea-Suan Lin wrote: > On Fri, Dec 16, 2005 at 08:06:09AM +0100, Rink Springer wrote: > >>>And you should disable these options, it may increase ~10% again: >>> >>>-cpu I486_CPU >>>-cpu I586_CPU >>> cpu I686_CPU >> >>A recent discussion on -STABLE warned against removing I586_CPU, refer >>to >>http://lists.freebsd.org/pipermail/freebsd-stable/2005-December/020696.html >>for more information. > > > Thanks, I'll try it later. > > BTW, did anyone try using jemalloc to test mysql ? > It was tried recently using supersmack and unix domain sockets. The results were slightly slower (around 6%, IIRC). The theory is that jemalloc doesn't pad out allocations as much, so there is high potential for cache line sharing (and thus cache thrash) between CPUs. Scott