From owner-freebsd-current@FreeBSD.ORG Thu Mar 30 06:58:43 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 DAA9216A41F for ; Thu, 30 Mar 2006 06:58:43 +0000 (UTC) (envelope-from ganbold@micom.mng.net) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4B84D43D53 for ; Thu, 30 Mar 2006 06:58:39 +0000 (GMT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=[192.168.0.18]) by publicd.ub.mng.net with esmtpa (Exim 4.60 (FreeBSD)) (envelope-from ) id 1FOrCM-000K7O-7m; Thu, 30 Mar 2006 16:04:02 +0900 Message-ID: <442B81B9.30206@micom.mng.net> Date: Thu, 30 Mar 2006 15:59:05 +0900 From: Ganbold User-Agent: Thunderbird 1.5 (X11/20060202) MIME-Version: 1.0 To: "Thyer, Matthew" References: <07018E951F2FBF42B40B3D61086788344C1D9D@ednex511.dsto.defence.gov.au> In-Reply-To: <07018E951F2FBF42B40B3D61086788344C1D9D@ednex511.dsto.defence.gov.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-current@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:58:43 -0000 Thyer, Matthew wrote: > A couple of things I have noticed in the kernel messages: > > WARNING: WITNESS option enabled, expect reduced performance. > Yes, I left this option in case if there comes something wrong. > You need to remove the WITNESS and the INVARIANTS options from your > kernel when benchmarking. > > ad0: DMA limited to UDMA33, controller found non-ATA66 cable > ad0: 28629MB at ata0-master UDMA33 > ad1: DMA limited to UDMA33, controller found non-ATA66 cable > ad1: 28629MB at ata0-slave UDMA33 > ad3: 38166MB at ata1-slave UDMA100 > > You need to use the 80 core conductor cables instead of the old standard > 40 core conductor IDE cables to get the best performance from your hard > drives. Just use another cable like you already have connected to the > 40GB drive. > That is true, I don't have any UDMA100 cables right now:( Ganbold > -----Original Message----- > From: owner-freebsd-current@freebsd.org > [mailto:owner-freebsd-current@freebsd.org] On Behalf Of Ganbold > Sent: Thursday, 30 March 2006 4:55 PM > To: freebsd-current@freebsd.org > Cc: jasone@freebsd.org; deischen@freebsd.org; phk@phk.freebsd.dk; > rwatson@freebsd.org; davidxu@freebsd.org; grog@freebsd.org > Subject: mysql performance test results under FreeBSD-7.0-CURRENT > > 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. > > The test results are at: > > http://www.mnbsd.org/ftp/mysql_test_results.txt > > 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? > > 2. I didn't make test with Robert Watson's patch > (http://www.watson.org/~robert/freebsd/clock/)? Does CURRENT src tree > include it? If not when this patch will be included in CURRENT? > > 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? > > thanks in advance, > > Ganbold > > > _______________________________________________ > freebsd-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to > "freebsd-current-unsubscribe@freebsd.org" > > > >