From owner-freebsd-current@FreeBSD.ORG Thu Mar 30 06:56:42 2006 Return-Path: X-Original-To: freebsd-current@freebsd.org Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1C16816A41F; Thu, 30 Mar 2006 06:56:42 +0000 (UTC) (envelope-from Alexander@Leidinger.net) Received: from www.ebusiness-leidinger.de (jojo.ms-net.de [84.16.236.246]) by mx1.FreeBSD.org (Postfix) with ESMTP id 11B1043D45; Thu, 30 Mar 2006 06:56:40 +0000 (GMT) (envelope-from Alexander@Leidinger.net) Received: from Andro-Beta.Leidinger.net (p54A5D949.dip.t-dialin.net [84.165.217.73]) (authenticated bits=0) by www.ebusiness-leidinger.de (8.13.4/8.13.1) with ESMTP id k2U6teZD070133; Thu, 30 Mar 2006 08:55:41 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from localhost (localhost [127.0.0.1]) by Andro-Beta.Leidinger.net (8.13.4/8.13.3) with ESMTP id k2U6ubgR020638; Thu, 30 Mar 2006 08:56:37 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from pslux.cec.eu.int (pslux.cec.eu.int [158.169.9.14]) by webmail.leidinger.net (Horde MIME library) with HTTP; Thu, 30 Mar 2006 08:56:37 +0200 Message-ID: <20060330085637.jsjbbeczwocogwcg@netchild.homeip.net> X-Priority: 3 (Normal) Date: Thu, 30 Mar 2006 08:56:37 +0200 From: Alexander Leidinger To: Ganbold References: <442B79AE.9000800@micom.mng.net> In-Reply-To: <442B79AE.9000800@micom.mng.net> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.3) / FreeBSD-4.11 X-Virus-Scanned: by amavisd-new Cc: jasone@freebsd.org, deischen@freebsd.org, phk@phk.freebsd.dk, freebsd-current@freebsd.org, rwatson@freebsd.org, davidxu@freebsd.org, grog@freebsd.org Subject: Re: mysql performance test results under FreeBSD-7.0-CURRENT 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: Thu, 30 Mar 2006 06:56:42 -0000 Ganbold wrote: > Hi all, > > I did make some mysql performance tests under FreeBSD-7.0-CURRENT > with various > scheduler and compile time options. > It seems like mysql(BUILD_OPTIMIZED=yes, BUILD_STATIC=yes, > WITH_PROC_SCOPE_PTH=yes)-libpthread-tsc-sched_4bsd+preemption gives > better performance. You should test without WITNESS (and maybe without INVARIANTS), as it's a safety net / debug feature for us developers. > There are several things I didn't test and this leads to some questions: > > 1. I didn't make test with Poul-Henning's CPU accounting patch. > Somehow I can't apply it > (http://phk.freebsd.dk/patch/cpu_acct_2.patch) cleanly. Where can I > find latest patch? > When this patch will be included in CURRENT? It looks like a different version of this patch is committed. > 3. I did make tests with default malloc in CURRENT. I'm confused what > malloc options should try (jemalloc? phkmalloc?) What is the default > malloc in CURRENT? How to use these different mallocs? The default in current is jemalloc as it is supposed to give a lot of benefits in the SMP case, and no no drawbacks in the UP case. The previous version is called phkmalloc. Have a look at "man malloc.conf" for tuning features. You can also disable some debug stuff by recompiling the world with "-DNO_MALLOC_EXTRAS" added to your CFLAGS. Bye, Alexander. -- http://www.Leidinger.net Alexander @ Leidinger.net: PGP ID = B0063FE7 http://www.FreeBSD.org netchild @ FreeBSD.org : PGP ID = 72077137 The further away the disaster or accident occurs, the greater the number of dead and injured required for it to become a story.