From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 00:37:26 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from localhost.my.domain (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 7B7E316A407 for ; Mon, 3 Jul 2006 00:37:26 +0000 (UTC) (envelope-from davidxu@freebsd.org) From: David Xu To: freebsd-performance@freebsd.org Date: Mon, 3 Jul 2006 08:37:04 +0800 User-Agent: KMail/1.8.2 References: <20060630001142.Y67344@fledge.watson.org> In-Reply-To: <20060630001142.Y67344@fledge.watson.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607030837.04685.davidxu@freebsd.org> Subject: Re: Updated fine-grain locking patch for UNIX domain sockets 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: Mon, 03 Jul 2006 00:37:26 -0000 On Friday 30 June 2006 07:14, Robert Watson wrote: > Attached, and at the below URL, find an updated copy of the UNIX domain > socket fine-grained locking patch. Since the last revision, I've updated > the patch to close several race conditions historically present in UNIX > domain sockets (which should be merged regardless of the rest of the > patch), as well as move to an rwlock for the global lock. > > > http://www.watson.org/~robert/freebsd/netperf/20060630-uds-fine-grain.diff > > This patch increases locking overhead, but decreases contention. Depending > on the number of CPUs, it may improve (or not) performance to varying > degrees; very good reports on sun4v; middling reports on 2-proc, etc. > Stability and performance results for UNIX domain socket sensitive > workloads, such as MySQL, X11, etc, would be appreciated. Micro-benchmark > performance should show a small loss, but load under contention and > scalability are (ideally) improved. > > Robert N M Watson > Computer Laboratory > University of Cambridge > I found 5% performance decrease on dual P4, maybe P4 is quite bad when doing atomic operation. ;-) Thanks, David Xu From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 00:43:10 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from localhost.my.domain (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 9E62516A40F; Mon, 3 Jul 2006 00:43:10 +0000 (UTC) (envelope-from davidxu@freebsd.org) From: David Xu To: freebsd-performance@freebsd.org Date: Mon, 3 Jul 2006 08:42:48 +0800 User-Agent: KMail/1.8.2 References: <14a4a8480606261918q39b51f7bkd69958c5a7b05021@mail.gmail.com> <20060627033412.GQ10845@wantadilla.lemis.com> In-Reply-To: <20060627033412.GQ10845@wantadilla.lemis.com> MIME-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607030842.48837.davidxu@freebsd.org> Cc: Greg 'groggy' Lehey , leo huang Subject: Re: Is the fsync() fake on FreeBSD6.1? 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: Mon, 03 Jul 2006 00:43:11 -0000 On Tuesday 27 June 2006 11:34, Greg 'groggy' Lehey wrote: > This is not the case for Linux, where fsync syncs the entire file > system. That could explain some of the performance difference, but > not all of it. I suppose it's worth noting that, in general, people > report much better performance with MySQL on Linux than on FreeBSD. > I recent have tested SCHED_CORE, the scheduler has same dynamic priority algorithm as Linux 2.6, it can make 10% performance boost for super-smack on my dual PIII, I tested it on local host, but its user interaction is quite bad under heavy load, scheduling alogrithm makes sense, but 4BSD is still best scheduler for me. > > I mean than the data is only written to the drives memory and so can > > be lost if power goes down. > > I don't believe that fsync is required to flush the drive buffers. It > would be nice to have a function that did, though. > > > And how I can confirm this? > > Trial and error? > > Greg > -- > See complete headers for address and phone numbers. From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 04:14:52 2006 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 6E7AB16A415 for ; Mon, 3 Jul 2006 04:14:52 +0000 (UTC) (envelope-from kip.macy@gmail.com) Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id A5B2D43D46 for ; Mon, 3 Jul 2006 04:14:51 +0000 (GMT) (envelope-from kip.macy@gmail.com) Received: by nz-out-0102.google.com with SMTP id 34so366303nzf for ; Sun, 02 Jul 2006 21:14:49 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=h5v0oOvhHX+G1zXKmrOTXdvex6GQ4E17sUImT7L4p4DaiI7ON90G46clAptH1JTqVNSZoNBLsLAENv9ETeigzO8udR74PUXU1vNMImvLnRq+U96JRqItBXXj9aZoaK6AdGqaoetBF4PTUP1oAXGDcMx6MLDqwEh1r++iTBu1R/I= Received: by 10.64.91.15 with SMTP id o15mr2656154qbb; Sun, 02 Jul 2006 21:14:49 -0700 (PDT) Received: by 10.65.225.9 with HTTP; Sun, 2 Jul 2006 21:14:49 -0700 (PDT) Message-ID: Date: Sun, 2 Jul 2006 21:14:49 -0700 From: "Kip Macy" To: "David Xu" In-Reply-To: <200607030837.04685.davidxu@freebsd.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20060630001142.Y67344@fledge.watson.org> <200607030837.04685.davidxu@freebsd.org> Cc: freebsd-performance@freebsd.org Subject: Re: Updated fine-grain locking patch for UNIX domain sockets X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: kmacy@fsmware.com List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 03 Jul 2006 04:14:52 -0000 > I found 5% performance decrease on dual P4, maybe P4 is quite bad when > doing atomic operation. ;-) Unfortunately, the consensus is that the only thing the P4 is better at is video games. -Kip From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 03:53:31 2006 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 50D3716A492 for ; Mon, 3 Jul 2006 03:53:31 +0000 (UTC) (envelope-from hugo@barafranca.com) Received: from mail.barafranca.com (mail.barafranca.com [67.19.101.164]) by mx1.FreeBSD.org (Postfix) with ESMTP id C183643E45 for ; Mon, 3 Jul 2006 03:53:21 +0000 (GMT) (envelope-from hugo@barafranca.com) Received: from localhost (localhost [127.0.0.1]) by mail.barafranca.com (Postfix) with ESMTP id 20B61C3822 for ; Mon, 3 Jul 2006 04:08:05 +0000 (UTC) Received: from mail.barafranca.com ([67.19.101.164]) by localhost (mail.barafranca.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30734-08 for ; Mon, 3 Jul 2006 04:08:03 +0000 (UTC) Received: from [192.168.0.1] (unknown [81.84.174.99]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.barafranca.com (Postfix) with ESMTP id 334C6C3828 for ; Mon, 3 Jul 2006 04:08:03 +0000 (UTC) Message-ID: <44A894B0.3010506@barafranca.com> Date: Mon, 03 Jul 2006 04:53:20 +0100 From: Hugo Silva User-Agent: Thunderbird 1.5.0.2 (X11/20060516) MIME-Version: 1.0 To: freebsd-performance@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at barafranca.com X-Mailman-Approved-At: Mon, 03 Jul 2006 05:02:45 +0000 Subject: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 03:53:31 -0000 Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE. This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks that do 320MB/s For all the tests, I restarted mysqld prior to starting the test, waited for about 1 minute for it to settle down, and ran super smack. For the consecutive runs, I executed super-smack right after the previous run ended. Switching from HTT to no HTT was achieved by machdep.hyperthreading_allowed, and switching from/to libpthread/libthr was done via libmap.conf. System: FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul 3 03:10:35 UTC 2006 ??@??:/usr/obj/usr/src/sys/DATABASE i386 Here are the results: MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes === 4BSD + libthr + HTT on === Run #1 connect: max=4ms min=1ms avg= 3ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 20405.86 Run #2 connect: max=3ms min=1ms avg= 2ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 20253.53 Run #3 connect: max=4ms min=2ms avg= 2ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 20270.33 === 4BSD + libthr + HTT off === Run #1 connect: max=5ms min=2ms avg= 3ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 18253.60 Run #2 connect: max=6ms min=1ms avg= 3ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 18350.27 Run #3 connect: max=4ms min=1ms avg= 2ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 18529.71 === 4BSD + libpthread + HTT on === Run #1: connect: max=17ms min=2ms avg= 7ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 5 0 3935.94 Run #2: connect: max=18ms min=1ms avg= 8ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 2 0 3919.89 Run #3: connect: max=22ms min=1ms avg= 13ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 2 0 3911.66 === 4BSD + libpthread + HTT off === connect: max=12ms min=1ms avg= 5ms from 10 clients Run #1: Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 11193.40 Run #2: connect: max=6ms min=4ms avg= 5ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 11428.30 Run #3: connect: max=7ms min=4ms avg= 5ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 1 0 13714.02 === ULE + libthr + HTT on === Run #1: connect: max=2ms min=0ms avg= 0ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 1 0 16179.09 Run #2: connect: max=14ms min=0ms avg= 7ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 17451.31 Run #3: connect: max=5ms min=1ms avg= 3ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 1 0 15787.02 === ULE + libthr + HTT off === Run #1: connect: max=6ms min=6ms avg= 6ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 11588.19 Run #2: connect: max=220ms min=2ms avg= 46ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 10651.16 Run #3: connect: max=10ms min=0ms avg= 5ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 10158.63 === ULE + libpthread + HTT on === Run #1: connect: max=9ms min=1ms avg= 7ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 2 0 5869.52 Run #2: Query_type num_queries max_time min_time q_per_s select_index 200000 2 0 5839.95 Run #3: Query_type num_queries max_time min_time q_per_s select_index 200000 2 0 5680.97 === ULE + libpthread + HTT off === Run #1: connect: max=10ms min=1ms avg= 8ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 6111.21 Run #2: connect: max=1597ms min=1ms avg= 177ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 7225.26 Run #3: connect: max=9ms min=1ms avg= 4ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 1 0 8187.13 Conclusions: 4BSD performed much better than ULE. libthr performs a lot better than libpthread. I'd risk saying libpthread has issues! Hyperthreading is sometimes benefitial. On the winning combination (4BSD+libthr), it is benefitial. On some other combinations (4BSD+libpthread), it seems to greatly impair performance. From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 06:17:51 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from [127.0.0.1] (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 7C51B16A403; Mon, 3 Jul 2006 06:17:50 +0000 (UTC) (envelope-from davidxu@freebsd.org) Message-ID: <44A8B68F.5060802@freebsd.org> Date: Mon, 03 Jul 2006 14:17:51 +0800 From: David Xu User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.12) Gecko/20060519 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hugo Silva References: <44A894B0.3010506@barafranca.com> In-Reply-To: <44A894B0.3010506@barafranca.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-performance@freebsd.org Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 06:17:51 -0000 Hugo Silva wrote: > > Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE. > This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks that > do 320MB/s > > For all the tests, I restarted mysqld prior to starting the test, > waited for about 1 minute for it to settle down, and ran super smack. > For the consecutive runs, I executed super-smack right after the > previous run ended. > > Switching from HTT to no HTT was achieved by > machdep.hyperthreading_allowed, and switching from/to libpthread/libthr > was done via libmap.conf. > > System: > > FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul 3 03:10:35 UTC > 2006 ??@??:/usr/obj/usr/src/sys/DATABASE i386 > > Here are the results: > > > MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes > > Please don't run mysql in PROC_SCOPE with libthr, it has no benefit and can only hurt performance, you can forcely turn it off by: sysctl kern.threads.thr_scope=2 the proc scope support may be dropped near future in libthr, thanks for your evaluation. David Xu From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 08:11:33 2006 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 B7E8C16A417 for ; Mon, 3 Jul 2006 08:11:33 +0000 (UTC) (envelope-from dinesh@alphaque.com) Received: from ns2.alphaque.com (ns2.alphaque.com [202.75.47.153]) by mx1.FreeBSD.org (Postfix) with SMTP id 01BDA43D58 for ; Mon, 3 Jul 2006 08:11:31 +0000 (GMT) (envelope-from dinesh@alphaque.com) Received: (qmail 91592 invoked by uid 0); 3 Jul 2006 08:11:28 -0000 Received: from lucifer.net-gw.com (HELO prophet.alphaque.com) (202.75.47.153) by lucifer.net-gw.com with SMTP; 3 Jul 2006 08:11:28 -0000 Received: from [127.0.0.1] (localhost [127.0.0.1]) by prophet.alphaque.com (8.13.6/8.13.4) with ESMTP id k6386fOQ011171; Mon, 3 Jul 2006 16:06:42 +0800 (MYT) (envelope-from dinesh@alphaque.com) Message-ID: <44A8D011.60305@alphaque.com> Date: Mon, 03 Jul 2006 16:06:41 +0800 From: Dinesh Nair User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8b) Gecko/20060213 MIME-Version: 1.0 To: David Xu References: <44A894B0.3010506@barafranca.com> <44A8B68F.5060802@freebsd.org> In-Reply-To: <44A8B68F.5060802@freebsd.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-performance@freebsd.org, Hugo Silva Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 08:11:33 -0000 On 07/03/06 14:17 David Xu said the following: > Please don't run mysql in PROC_SCOPE with libthr, it has no benefit and > can only hurt performance, you can forcely turn it off by: still, libthr showed oodles better performance than libpthread. is this indicative ? -- Regards, /\_/\ "All dogs go to heaven." dinesh@alphaque.com (0 0) http://www.openmalaysiablog.com/ +==========================----oOO--(_)--OOo----==========================+ | for a in past present future; do | | for b in clients employers associates relatives neighbours pets; do | | echo "The opinions here in no way reflect the opinions of my $a $b." | | done; done | +=========================================================================+ From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 08:17:01 2006 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 4528F16A47C for ; Mon, 3 Jul 2006 08:17:01 +0000 (UTC) (envelope-from mv@thebeastie.org) Received: from p4.roq.com (ns1.ecoms.com [207.44.130.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8F21643E35 for ; Mon, 3 Jul 2006 08:16:51 +0000 (GMT) (envelope-from mv@thebeastie.org) Received: from p4.roq.com (localhost.roq.com [127.0.0.1]) by p4.roq.com (Postfix) with ESMTP id E5D054D144 for ; Mon, 3 Jul 2006 08:17:01 +0000 (GMT) Received: from vaulte.jumbuck.com (ppp166-27.static.internode.on.net [150.101.166.27]) by p4.roq.com (Postfix) with ESMTP id 745954D141 for ; Mon, 3 Jul 2006 08:17:01 +0000 (GMT) Received: from vaulte.jumbuck.com (localhost [127.0.0.1]) by vaulte.jumbuck.com (Postfix) with ESMTP id 0EAE48A023; Mon, 3 Jul 2006 18:16:49 +1000 (EST) Received: from [192.168.46.102] (unknown [192.168.46.250]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by vaulte.jumbuck.com (Postfix) with ESMTP id 0AC818A00D; Mon, 3 Jul 2006 18:16:49 +1000 (EST) Message-ID: <44A8D270.1080009@thebeastie.org> Date: Mon, 03 Jul 2006 18:16:48 +1000 From: Michael Vince User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.7.12) Gecko/20060404 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hugo Silva References: <44A894B0.3010506@barafranca.com> In-Reply-To: <44A894B0.3010506@barafranca.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: ClamAV using ClamSMTP Cc: freebsd-performance@freebsd.org Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 08:17:01 -0000 Hugo Silva wrote: > Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE. > This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks > that do 320MB/s > > For all the tests, I restarted mysqld prior to starting the test, > waited for about 1 minute for it to settle down, and ran super smack. > For the consecutive runs, I executed super-smack right after the > previous run ended. > > Switching from HTT to no HTT was achieved by > machdep.hyperthreading_allowed, and switching from/to > libpthread/libthr was done via libmap.conf. > > System: > > FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul 3 03:10:35 UTC > 2006 ??@??:/usr/obj/usr/src/sys/DATABASE i386 > > Here are the results: > > > MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes > > > === 4BSD + libthr + HTT on === > > Run #1 > connect: max=4ms min=1ms avg= 3ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 200000 0 0 20405.86 > > I think that this, does show impressive scaling to actually see performance increase with HTT enabled, from what I have seen on benchmarks on many hardware sites testing on MS Windows is that on the average best you get is an extra 5% performance out of HTT per core. I don't have any quad core machines either, but my dual CPU Dells that are around 3.[46]ghz get score of around 25,000 The other promising benchmark I saw on per CPU scaling was a few months ago with a posted super smack benchmark on a -current box that was getting a score of around 60,000 on a slightly better Quad core AMD64 machine which proves consistent scaling per core, which as far as my memory goes shows good scaling when entering the 4+ core arena on MySQL. Mike > > === 4BSD + libthr + HTT off === > > Run #1 > connect: max=5ms min=2ms avg= 3ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 200000 0 0 18253.60 From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 10:04:49 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from [127.0.0.1] (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id CEB3016A403; Mon, 3 Jul 2006 10:04:46 +0000 (UTC) (envelope-from davidxu@freebsd.org) Message-ID: <44A8EBC0.5090805@freebsd.org> Date: Mon, 03 Jul 2006 18:04:48 +0800 From: David Xu User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.12) Gecko/20060519 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Vince References: <44A894B0.3010506@barafranca.com> <44A8D270.1080009@thebeastie.org> In-Reply-To: <44A8D270.1080009@thebeastie.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-performance@freebsd.org, Hugo Silva Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 10:04:49 -0000 Michael Vince wrote: > > Hugo Silva wrote: > >> Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE. >> This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks >> that do 320MB/s >> >> For all the tests, I restarted mysqld prior to starting the test, >> waited for about 1 minute for it to settle down, and ran super smack. >> For the consecutive runs, I executed super-smack right after the >> previous run ended. >> >> Switching from HTT to no HTT was achieved by >> machdep.hyperthreading_allowed, and switching from/to >> libpthread/libthr was done via libmap.conf. >> >> System: >> >> FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul 3 03:10:35 UTC >> 2006 ??@??:/usr/obj/usr/src/sys/DATABASE i386 >> >> Here are the results: >> >> >> MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes >> >> >> === 4BSD + libthr + HTT on === >> >> Run #1 >> connect: max=4ms min=1ms avg= 3ms from 10 clients >> Query_type num_queries max_time min_time q_per_s >> select_index 200000 0 0 20405.86 >> >> > I think that this, does show impressive scaling to actually see > performance increase with HTT enabled, from what I have seen on > benchmarks on many hardware sites testing on MS Windows is that on the > average best you get is an extra 5% performance out of HTT per core. > I don't have any quad core machines either, but my dual CPU Dells that > are around 3.[46]ghz get score of around 25,000 > > The other promising benchmark I saw on per CPU scaling was a few months > ago with a posted super smack benchmark on a -current box that was > getting a score of around 60,000 on a slightly better Quad core AMD64 > machine which proves consistent scaling per core, which as far as my > memory goes shows good scaling when entering the 4+ core arena on MySQL. > > Mike > Actually, with proper scheduling behaviour, HTT is usefull, I saw very high performance boosts when running sysbench : sysbench --test=oltp --oltp-table-size=1000000 --mysql-host=192.168.82.170 --mysql-user=test --mysql-db=test --oltp-read-only --num-threads=256 --max-requests=10000 run This benchmark runs on my Dual XEON (2.8Ghz, HTT enabled), when the scheduler is SCHED_CORE, it only requires 30 seconds, while a 4bsd scheduler needs 52 seconds, last time, I wrongly wiped some code in SCHED_CORE (which is now in tree), performance is degraded. I need some time to make the scheduler works properly. David Xu From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 12:45:50 2006 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 B8CF416A412; Mon, 3 Jul 2006 12:45:50 +0000 (UTC) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6612543D55; Mon, 3 Jul 2006 12:45:50 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [209.31.154.41]) by cyrus.watson.org (Postfix) with ESMTP id 645D946C45; Mon, 3 Jul 2006 08:45:49 -0400 (EDT) Date: Mon, 3 Jul 2006 13:45:49 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: David Xu In-Reply-To: <200607030837.04685.davidxu@freebsd.org> Message-ID: <20060703134429.P57091@fledge.watson.org> References: <20060630001142.Y67344@fledge.watson.org> <200607030837.04685.davidxu@freebsd.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-performance@freebsd.org Subject: Re: Updated fine-grain locking patch for UNIX domain sockets 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: Mon, 03 Jul 2006 12:45:50 -0000 On Mon, 3 Jul 2006, David Xu wrote: > I found 5% performance decrease on dual P4, maybe P4 is quite bad when doing > atomic operation. ;-) Thanks, When I've measured, generally, yes, P4 performance has been abysmal for synchronization operations, both atomic operations and CPU-local interrupt disabling, etc. I suspect rwlocks could use a bit of optimization in the contention case. I've not dug into the code, so I'm not clear how they compare with respect to adaptive behavior. Robert N M Watson Computer Laboratory University of Cambridge From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 15:20:46 2006 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 A6BBE16A407; Mon, 3 Jul 2006 15:20:46 +0000 (UTC) (envelope-from mv@thebeastie.org) Received: from p4.roq.com (ns1.ecoms.com [207.44.130.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id D382443D6B; Mon, 3 Jul 2006 15:20:39 +0000 (GMT) (envelope-from mv@thebeastie.org) Received: from p4.roq.com (localhost.roq.com [127.0.0.1]) by p4.roq.com (Postfix) with ESMTP id D1DF04CED9; Mon, 3 Jul 2006 15:20:50 +0000 (GMT) Received: from vaulte.jumbuck.com (ppp166-27.static.internode.on.net [150.101.166.27]) by p4.roq.com (Postfix) with ESMTP id 21B2D4CED4; Mon, 3 Jul 2006 15:20:50 +0000 (GMT) Received: from vaulte.jumbuck.com (localhost [127.0.0.1]) by vaulte.jumbuck.com (Postfix) with ESMTP id C839B8A031; Tue, 4 Jul 2006 01:20:36 +1000 (EST) Received: from [192.168.0.6] (ppp157-158.static.internode.on.net [150.101.157.158]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by vaulte.jumbuck.com (Postfix) with ESMTP id 7405E8A029; Tue, 4 Jul 2006 01:20:36 +1000 (EST) Message-ID: <44A935C7.3070605@thebeastie.org> Date: Tue, 04 Jul 2006 01:20:39 +1000 From: Michael Vince User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.13) Gecko/20060526 X-Accept-Language: en-us, en MIME-Version: 1.0 To: David Xu References: <44A894B0.3010506@barafranca.com> <44A8D270.1080009@thebeastie.org> <44A8EBC0.5090805@freebsd.org> In-Reply-To: <44A8EBC0.5090805@freebsd.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: ClamAV using ClamSMTP Cc: freebsd-performance@freebsd.org, Hugo Silva Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 15:20:46 -0000 David Xu wrote: > Michael Vince wrote: > >> >> Hugo Silva wrote: >> >>> Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE. >>> This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks >>> that do 320MB/s >>> >>> For all the tests, I restarted mysqld prior to starting the test, >>> waited for about 1 minute for it to settle down, and ran super >>> smack. For the consecutive runs, I executed super-smack right after >>> the previous run ended. >>> >>> Switching from HTT to no HTT was achieved by >>> machdep.hyperthreading_allowed, and switching from/to >>> libpthread/libthr was done via libmap.conf. >>> >>> System: >>> >>> FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul 3 03:10:35 UTC >>> 2006 ??@??:/usr/obj/usr/src/sys/DATABASE i386 >>> >>> Here are the results: >>> >>> >>> MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and >>> WITH_PROC_SCOPE_PTH=yes >>> >>> >>> === 4BSD + libthr + HTT on === >>> >>> Run #1 >>> connect: max=4ms min=1ms avg= 3ms from 10 clients >>> Query_type num_queries max_time min_time q_per_s >>> select_index 200000 0 0 20405.86 >>> >>> >> I think that this, does show impressive scaling to actually see >> performance increase with HTT enabled, from what I have seen on >> benchmarks on many hardware sites testing on MS Windows is that on >> the average best you get is an extra 5% performance out of HTT per core. >> I don't have any quad core machines either, but my dual CPU Dells >> that are around 3.[46]ghz get score of around 25,000 >> >> The other promising benchmark I saw on per CPU scaling was a few >> months ago with a posted super smack benchmark on a -current box that >> was getting a score of around 60,000 on a slightly better Quad core >> AMD64 machine which proves consistent scaling per core, which as far >> as my memory goes shows good scaling when entering the 4+ core arena >> on MySQL. >> >> Mike >> > > Actually, with proper scheduling behaviour, HTT is usefull, > I saw very high performance boosts when running sysbench : > > sysbench --test=oltp --oltp-table-size=1000000 > --mysql-host=192.168.82.170 --mysql-user=test --mysql-db=test > --oltp-read-only --num-threads=256 --max-requests=10000 run > > This benchmark runs on my Dual XEON (2.8Ghz, HTT enabled), when the > scheduler is SCHED_CORE, it only requires 30 seconds, while a 4bsd > scheduler needs 52 seconds, last time, I wrongly wiped some code in > SCHED_CORE (which is now in tree), performance is degraded. > I need some time to make the scheduler works properly. > > David Xu That sounds very promising. Also note when I said 5% performance improvement as average best I was referring to real world benchmark tests that you see typically on Anandtech and so on, maybe this rule of thumb has changed over time, (I remember reading as Anands view on HTT at one time in the past) I have tended to see (and also read it so ) that HTT is largely just a 5% real world freebie that Intel created to get software developers thinking MP so when the real dual and eventually quad cores were released, there would be some software for mainstream consumers to benefit from, ready to take advantage of their new CPUs. Its probably hard for Intel to forget that it took MS 10 years since the release of the i386 chip to release a mass consumer almost purely 32bit OS that being Windows 2000 and XP (don't argue NT4 was for the average home user). HTT was Intels best early stab to help path the way for their multi core technologies to come into use as quickly as possible for the masses over just the server end. Mike From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 18:39:17 2006 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 7266916A492; Mon, 3 Jul 2006 18:39:17 +0000 (UTC) (envelope-from mikej@rogers.com) Received: from H43.C18.B96.tor.eicat.ca (H43.C18.B96.tor.eicat.ca [66.96.18.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6899A43D45; Mon, 3 Jul 2006 18:39:16 +0000 (GMT) (envelope-from mikej@rogers.com) Received: from [172.16.0.200] (desktop.home.local [172.16.0.200]) by H43.C18.B96.tor.eicat.ca (Postfix) with ESMTP id 7C43E114CE; Mon, 3 Jul 2006 14:38:48 -0400 (EDT) Message-ID: <44A96485.4030604@rogers.com> Date: Mon, 03 Jul 2006 14:40:05 -0400 From: Mike Jakubik User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Michael Vince References: <44A894B0.3010506@barafranca.com> <44A8D270.1080009@thebeastie.org> <44A8EBC0.5090805@freebsd.org> <44A935C7.3070605@thebeastie.org> In-Reply-To: <44A935C7.3070605@thebeastie.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SpamToaster-Information: This messages has been scanned by SpamToaster http://www.digitalprogression.ca X-SpamToaster: Found to be clean X-SpamToaster-SpamCheck: not spam, SpamAssassin (not cached, score=-2.491, required 3.5, ALL_TRUSTED -1.80, BAYES_00 -2.60, DNS_FROM_RFC_ABUSE 0.20, DNS_FROM_RFC_POST 1.71) X-SpamToaster-From: mikej@rogers.com X-Spam-Status: No Cc: freebsd-performance@freebsd.org, David Xu , Hugo Silva Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 18:39:17 -0000 Michael Vince wrote: > HTT was Intels best early stab to help path the way for their multi > core technologies to come into use as quickly as possible for the > masses over just the server end. Exactly, thats why i wouldn't spend too much time bothering with HTT. It was a transitional technology for multi core CPUs, which are now the standard. It will be interesting how the new Conroe processors fair on FreeBSD, the early benchmarks show better performance than AMDs offerings. From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 22:21:31 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from localhost.my.domain (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 3F0B916A407; Mon, 3 Jul 2006 22:21:31 +0000 (UTC) (envelope-from davidxu@freebsd.org) From: David Xu To: Mike Jakubik Date: Tue, 4 Jul 2006 06:21:08 +0800 User-Agent: KMail/1.8.2 References: <44A894B0.3010506@barafranca.com> <44A935C7.3070605@thebeastie.org> <44A96485.4030604@rogers.com> In-Reply-To: <44A96485.4030604@rogers.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607040621.08886.davidxu@freebsd.org> Cc: freebsd-performance@freebsd.org, Hugo Silva , Michael Vince Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 22:21:31 -0000 On Tuesday 04 July 2006 02:40, Mike Jakubik wrote: > Michael Vince wrote: > > HTT was Intels best early stab to help path the way for their multi > > core technologies to come into use as quickly as possible for the > > masses over just the server end. > > Exactly, thats why i wouldn't spend too much time bothering with HTT. It > was a transitional technology for multi core CPUs, which are now the > standard. It will be interesting how the new Conroe processors fair on > FreeBSD, the early benchmarks show better performance than AMDs offerings. For conroe, google the "fair-cache", you may find what should be done in scheduler, that's one of many reasons why I was saying libpthread should be stopped. Unless conroe is very special and does not need this work. From owner-freebsd-performance@FreeBSD.ORG Mon Jul 3 22:31:20 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from localhost.my.domain (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 05C4A16A4DD; Mon, 3 Jul 2006 22:31:20 +0000 (UTC) (envelope-from davidxu@freebsd.org) From: David Xu To: Mike Jakubik Date: Tue, 4 Jul 2006 06:30:56 +0800 User-Agent: KMail/1.8.2 References: <44A894B0.3010506@barafranca.com> <44A96485.4030604@rogers.com> <200607040621.08886.davidxu@freebsd.org> In-Reply-To: <200607040621.08886.davidxu@freebsd.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607040630.56918.davidxu@freebsd.org> Cc: freebsd-performance@freebsd.org, Hugo Silva , Michael Vince Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark 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: Mon, 03 Jul 2006 22:31:20 -0000 On Tuesday 04 July 2006 06:21, David Xu wrote: > For conroe, google the "fair-cache", you may find what should be done > in scheduler, that's one of many reasons why I was saying libpthread should > be stopped. Unless conroe is very special and does not need this > work. Here is one of such interesting paper: http://people.freebsd.org/~davidxu/doc/osdi-2006-submission.pdf From owner-freebsd-performance@FreeBSD.ORG Tue Jul 4 11:32:31 2006 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 9BD8C16A4DF; Tue, 4 Jul 2006 11:32:31 +0000 (UTC) (envelope-from rwatson@FreeBSD.org) Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4140143D49; Tue, 4 Jul 2006 11:32:31 +0000 (GMT) (envelope-from rwatson@FreeBSD.org) Received: from fledge.watson.org (fledge.watson.org [209.31.154.41]) by cyrus.watson.org (Postfix) with ESMTP id DABDA46BC6; Tue, 4 Jul 2006 07:32:30 -0400 (EDT) Date: Tue, 4 Jul 2006 12:32:30 +0100 (BST) From: Robert Watson X-X-Sender: robert@fledge.watson.org To: David Xu In-Reply-To: <20060703134429.P57091@fledge.watson.org> Message-ID: <20060704123124.S44010@fledge.watson.org> References: <20060630001142.Y67344@fledge.watson.org> <200607030837.04685.davidxu@freebsd.org> <20060703134429.P57091@fledge.watson.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-performance@freebsd.org Subject: Re: Updated fine-grain locking patch for UNIX domain sockets 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: Tue, 04 Jul 2006 11:32:31 -0000 On Mon, 3 Jul 2006, Robert Watson wrote: > On Mon, 3 Jul 2006, David Xu wrote: > >> I found 5% performance decrease on dual P4, maybe P4 is quite bad when >> doing atomic operation. ;-) Thanks, > > When I've measured, generally, yes, P4 performance has been abysmal for > synchronization operations, both atomic operations and CPU-local interrupt > disabling, etc. > > I suspect rwlocks could use a bit of optimization in the contention case. > I've not dug into the code, so I'm not clear how they compare with respect > to adaptive behavior. I ran some micro-benchmarks, and rwlocks don't perform substantially differently from sleep mutexes for uncontended operation -- I've not measured cost under contention, however. Robert N M Watson Computer Laboratory University of Cambridge From owner-freebsd-performance@FreeBSD.ORG Wed Jul 5 01:20:47 2006 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 0F8C616A4DD for ; Wed, 5 Jul 2006 01:20:47 +0000 (UTC) (envelope-from danial_thom@yahoo.com) Received: from web33306.mail.mud.yahoo.com (web33306.mail.mud.yahoo.com [68.142.206.121]) by mx1.FreeBSD.org (Postfix) with SMTP id A05E243D46 for ; Wed, 5 Jul 2006 01:20:46 +0000 (GMT) (envelope-from danial_thom@yahoo.com) Received: (qmail 47949 invoked by uid 60001); 5 Jul 2006 01:20:46 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=i1JvmmG934VkBQSN/1JT8/C7tpt+zSD4d73sC3rjY7FUh1Qh5cP5zy7KeCVBjbWB9N4BIcpFU3w7H58JH4hUFB7qXRXtrxVFkjbtlGLh57KxRQTE7uwZIZZT+pxFoW+D51LPLw2zA/uLKzPRAuHjLq2CffNYIdf7btJhDJyaO+U= ; Message-ID: <20060705012046.47947.qmail@web33306.mail.mud.yahoo.com> Received: from [24.46.186.215] by web33306.mail.mud.yahoo.com via HTTP; Tue, 04 Jul 2006 18:20:46 PDT Date: Tue, 4 Jul 2006 18:20:46 -0700 (PDT) From: Danial Thom To: Hugo Silva , freebsd-performance@freebsd.org In-Reply-To: <44A894B0.3010506@barafranca.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: danial_thom@yahoo.com List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jul 2006 01:20:47 -0000 --- Hugo Silva wrote: > Today I decided to benchmark MySQL 5 > performance on FreeBSD 6.1-STABLE. > This server is a Dual Xeon 2.8GHz, 4GB of RAM > and 2x73GB SCSI disks that > do 320MB/s > > For all the tests, I restarted mysqld prior to > starting the test, > waited for about 1 minute for it to settle > down, and ran super smack. > For the consecutive runs, I executed > super-smack right after the > previous run ended. > > Switching from HTT to no HTT was achieved by > machdep.hyperthreading_allowed, and switching > from/to libpthread/libthr > was done via libmap.conf. > > System: > > FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: > Mon Jul 3 03:10:35 UTC > 2006 ??@??:/usr/obj/usr/src/sys/DATABASE > i386 > > Here are the results: > > > MySQL 5.0.22, built with BUILD_OPTIMIZED=yes > and WITH_PROC_SCOPE_PTH=yes > > > === 4BSD + libthr + HTT on === > > Run #1 > connect: max=4ms min=1ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 20405.86 > > Run #2 > connect: max=3ms min=1ms avg= 2ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 20253.53 > > Run #3 > connect: max=4ms min=2ms avg= 2ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 20270.33 > > > > > === 4BSD + libthr + HTT off === > > Run #1 > connect: max=5ms min=2ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 18253.60 > > Run #2 > connect: max=6ms min=1ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 18350.27 > > Run #3 > connect: max=4ms min=1ms avg= 2ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 18529.71 > > > === 4BSD + libpthread + HTT on === > > Run #1: > connect: max=17ms min=2ms avg= 7ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 5 0 > 3935.94 > > > Run #2: > connect: max=18ms min=1ms avg= 8ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 2 0 > 3919.89 > > Run #3: > connect: max=22ms min=1ms avg= 13ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 2 0 > 3911.66 > > > === 4BSD + libpthread + HTT off === > connect: max=12ms min=1ms avg= 5ms from 10 > clients > > Run #1: > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 11193.40 > > Run #2: > connect: max=6ms min=4ms avg= 5ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 11428.30 > > Run #3: > connect: max=7ms min=4ms avg= 5ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 1 0 > 13714.02 > > > > > > > > > > > > === ULE + libthr + HTT on === > Run #1: > connect: max=2ms min=0ms avg= 0ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 1 0 > 16179.09 > > Run #2: > connect: max=14ms min=0ms avg= 7ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 17451.31 > > Run #3: > connect: max=5ms min=1ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 1 0 > 15787.02 > > > === ULE + libthr + HTT off === > > Run #1: > connect: max=6ms min=6ms avg= 6ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 11588.19 > > Run #2: > connect: max=220ms min=2ms avg= 46ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 10651.16 > > Run #3: > connect: max=10ms min=0ms avg= 5ms from 10 > clients > Query_type num_queries max_time > min_time === message truncated === Instead of wasting your time with BS benchmarks, why not write a little script that does actual queries that you might be doing on a real, fully populated database? And make sure you test with 1 cpu. I don't see any "scaling" from 1 cpu to 2, so I can't get too excited about supersmack's miniscule scaling. The only scaling I see going from 1 cpu to 2 is about 300 extra dollars for the dual-core cpu. Besides, HTT will slow everything else on the system down, so its not practical to turn it on. For every benchmark that shows a tiny bit of improvement there are 5 that show degradation. DT __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From owner-freebsd-performance@FreeBSD.ORG Wed Jul 5 03:02:20 2006 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 703C516A4DE for ; Wed, 5 Jul 2006 03:02:20 +0000 (UTC) (envelope-from kip.macy@gmail.com) Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id F204543D5A for ; Wed, 5 Jul 2006 03:02:17 +0000 (GMT) (envelope-from kip.macy@gmail.com) Received: by nz-out-0102.google.com with SMTP id 34so781165nzf for ; Tue, 04 Jul 2006 20:02:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=VAwaVdbJWu5mW/5gduC88uD6T831ZXIdZmSoaHOKEVc/EuJ2CaUmqvtng4ullBuTRzXWMWJ7SLkNy8T0EAF7zLcjQ0JF9x9NgZ8SZL0ePi+oxGke3p/bq+9VctcmE9xqTzchAXnED66xZW+WYdQ1tM+f1L4/jHbOUnOb5R3CIYk= Received: by 10.64.83.10 with SMTP id g10mr4725859qbb; Tue, 04 Jul 2006 20:02:17 -0700 (PDT) Received: by 10.65.225.9 with HTTP; Tue, 4 Jul 2006 20:02:17 -0700 (PDT) Message-ID: Date: Tue, 4 Jul 2006 20:02:17 -0700 From: "Kip Macy" To: "Hugo Silva" In-Reply-To: <20060705012046.47947.qmail@web33306.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44A894B0.3010506@barafranca.com> <20060705012046.47947.qmail@web33306.mail.mud.yahoo.com> Cc: freebsd-performance@freebsd.org Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: kmacy@fsmware.com List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jul 2006 03:02:20 -0000 The FreeBSD zookeepers politely request that visitors not feed the trolls. -Kip On 7/4/06, Danial Thom wrote: > > > --- Hugo Silva wrote: > > > Today I decided to benchmark MySQL 5 > > performance on FreeBSD 6.1-STABLE. > > This server is a Dual Xeon 2.8GHz, 4GB of RAM > > and 2x73GB SCSI disks that > > do 320MB/s > > > > For all the tests, I restarted mysqld prior to > > starting the test, > > waited for about 1 minute for it to settle > > down, and ran super smack. > > For the consecutive runs, I executed > > super-smack right after the > > previous run ended. > > > > Switching from HTT to no HTT was achieved by > > machdep.hyperthreading_allowed, and switching > > from/to libpthread/libthr > > was done via libmap.conf. > > > > System: > > > > FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: > > Mon Jul 3 03:10:35 UTC > > 2006 ??@??:/usr/obj/usr/src/sys/DATABASE > > i386 > > > > Here are the results: > > > > > > MySQL 5.0.22, built with BUILD_OPTIMIZED=yes > > and WITH_PROC_SCOPE_PTH=yes > > > > > > === 4BSD + libthr + HTT on === > > > > Run #1 > > connect: max=4ms min=1ms avg= 3ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 20405.86 > > > > Run #2 > > connect: max=3ms min=1ms avg= 2ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 20253.53 > > > > Run #3 > > connect: max=4ms min=2ms avg= 2ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 20270.33 > > > > > > > > > > === 4BSD + libthr + HTT off === > > > > Run #1 > > connect: max=5ms min=2ms avg= 3ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 18253.60 > > > > Run #2 > > connect: max=6ms min=1ms avg= 3ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 18350.27 > > > > Run #3 > > connect: max=4ms min=1ms avg= 2ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 18529.71 > > > > > > === 4BSD + libpthread + HTT on === > > > > Run #1: > > connect: max=17ms min=2ms avg= 7ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 5 0 > > 3935.94 > > > > > > Run #2: > > connect: max=18ms min=1ms avg= 8ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 2 0 > > 3919.89 > > > > Run #3: > > connect: max=22ms min=1ms avg= 13ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 2 0 > > 3911.66 > > > > > > === 4BSD + libpthread + HTT off === > > connect: max=12ms min=1ms avg= 5ms from 10 > > clients > > > > Run #1: > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 11193.40 > > > > Run #2: > > connect: max=6ms min=4ms avg= 5ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 11428.30 > > > > Run #3: > > connect: max=7ms min=4ms avg= 5ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 1 0 > > 13714.02 > > > > > > > > > > > > > > > > > > > > > > > > === ULE + libthr + HTT on === > > Run #1: > > connect: max=2ms min=0ms avg= 0ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 1 0 > > 16179.09 > > > > Run #2: > > connect: max=14ms min=0ms avg= 7ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 17451.31 > > > > Run #3: > > connect: max=5ms min=1ms avg= 3ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 1 0 > > 15787.02 > > > > > > === ULE + libthr + HTT off === > > > > Run #1: > > connect: max=6ms min=6ms avg= 6ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 11588.19 > > > > Run #2: > > connect: max=220ms min=2ms avg= 46ms from 10 > > clients > > Query_type num_queries max_time > > min_time q_per_s > > select_index 200000 0 0 > > 10651.16 > > > > Run #3: > > connect: max=10ms min=0ms avg= 5ms from 10 > > clients > > Query_type num_queries max_time > > min_time > === message truncated === > > > Instead of wasting your time with BS benchmarks, > why not write a little script that does actual > queries that you might be doing on a real, fully > populated database? And make sure you test with 1 > cpu. I don't see any "scaling" from 1 cpu to 2, > so I can't get too excited about supersmack's > miniscule scaling. The only scaling I see going > from 1 cpu to 2 is about 300 extra dollars for > the dual-core cpu. > > Besides, HTT will slow everything else on the > system down, so its not practical to turn it on. > For every benchmark that shows a tiny bit of > improvement there are 5 that show degradation. > > DT > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > 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" > From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 01:02:58 2006 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 77A9016A4E1 for ; Thu, 6 Jul 2006 01:02:58 +0000 (UTC) (envelope-from dwoolworth@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by mx1.FreeBSD.org (Postfix) with ESMTP id F121143D49 for ; Thu, 6 Jul 2006 01:02:56 +0000 (GMT) (envelope-from dwoolworth@gmail.com) Received: by nf-out-0910.google.com with SMTP id o60so18066nfa for ; Wed, 05 Jul 2006 18:02:55 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=mEgZxGRPow8dy+LMu+fgCbY6QJX/nci/fbVlJxP1xOS8cnS0Ox0JprWEaGZScPl+cx03BOmsYIidBzm7LQU0boAbGRXxXtfw9rhs3ekEmuuT9yWxCLGFQltO6EiubDjFsZnJ4aAqmt5mGdX/PkQE0RQEki/V+XCjRi7eAEAP0Ps= Received: by 10.48.242.11 with SMTP id p11mr80867nfh; Wed, 05 Jul 2006 18:02:55 -0700 (PDT) Received: by 10.48.207.4 with HTTP; Wed, 5 Jul 2006 18:02:55 -0700 (PDT) Message-ID: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> Date: Wed, 5 Jul 2006 20:02:55 -0500 From: "Derrick T. Woolworth" To: freebsd-questions@freebsd.org, freebsd-performance@freebsd.org, freebsd-hackers@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: SATA300 Controllers 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: Thu, 06 Jul 2006 01:02:58 -0000 Hello all, Sorry for cross-posting, but these issues seem relevant for lists... Has anyone had success with SATA300 controllers with FreeBSD 6.1? I've been trying Promise and nVidia nForce4 and I'm not having any luck. Using a MSI K8NGM2-L motherboard and others, but 6.1's installation hangs as soon as it sees ad4. I've also tried using an Adaptec 1210SA controller and had zero results. I've read that the chipset on this controller is not very good - forces serialized access to the controller's channels??? Nevertheless, I've got a K8N Diamond motherboard on a workstation and I was able to at least "start" the 6.1 installation. I have no idea if its stable. At this point, I'd settle for just knowing "which" SATA300 controller to use that will work successfully and "well" with FreeBSD 6.0 OR 6.1. Another question, would I have more success installing 6.0 and then upgrading the kernel and recompiling with a build-world? I'm currently trying to build a moderate large system with 4 presentation servers, 2 database servers and one large storage system using NFS mapped to ~1.2 terrabyte of SATA disks (4x Maxtor 500GB 7200 RPM disks w/RAID5 config). Any suggestions? Thanks, Derrick From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 01:23:59 2006 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 4222516A4DA; Thu, 6 Jul 2006 01:23:59 +0000 (UTC) (envelope-from drechsau@Geeks.ORG) Received: from mail.geeks.org (jacobs.Geeks.ORG [204.153.247.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id A31B243D46; Thu, 6 Jul 2006 01:23:58 +0000 (GMT) (envelope-from drechsau@Geeks.ORG) Received: by mail.geeks.org (Postfix, from userid 1000) id 9EA2E15905A; Wed, 5 Jul 2006 20:23:57 -0500 (CDT) Date: Wed, 5 Jul 2006 20:23:57 -0500 From: Mike Horwath To: "Derrick T. Woolworth" Message-ID: <20060706012357.GB80086@Geeks.ORG> Mail-Followup-To: "Derrick T. Woolworth" , freebsd-questions@freebsd.org, freebsd-performance@freebsd.org, freebsd-hackers@freebsd.org References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> X-PGP-Fingerprint: D8 24 CC E6 47 5F E4 60 BF B7 6E FA BF C7 6E C5 X-GPG-Fingerprint: 6A89 E78A B8B1 69D9 8CDB E966 4A5A C3F9 A1B0 C381 User-Agent: mutt-ng/devel-r804 (FreeBSD) Cc: freebsd-hackers@freebsd.org, freebsd-performance@freebsd.org, freebsd-questions@freebsd.org Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 01:23:59 -0000 On Wed, Jul 05, 2006 at 08:02:55PM -0500, Derrick T. Woolworth wrote: > Sorry for cross-posting, but these issues seem relevant for lists... That's okay, I am not on all and I'll create some bounces, I am sure. > Has anyone had success with SATA300 controllers with FreeBSD 6.1? > I've been trying Promise and nVidia nForce4 and I'm not having any > luck. Using a MSI K8NGM2-L motherboard and others, but 6.1's > installation hangs as soon as it sees ad4. I've also tried using an > Adaptec 1210SA controller and had zero results. I've read that the > chipset on this controller is not very good - forces serialized > access to the controller's channels??? Nevertheless, I've got a K8N > Diamond motherboard on a workstation and I was able to at least > "start" the 6.1 installation. I have no idea if its stable. At > this point, I'd settle for just knowing "which" SATA300 controller > to use that will work successfully and "well" with FreeBSD 6.0 OR > 6.1. Another question, would I have more success installing 6.0 and > then upgrading the kernel and recompiling with a build-world? I am running 6.0 and 6.1 systems (-STABLE) with both ARECA 12xx cards and 3WARE/AMCC 9550SX cards. Neither are cheap, but they are doing the job and are in use in binary spoolers for news. > I'm currently trying to build a moderate large system with 4 presentation > servers, 2 database servers and one large storage system using NFS mapped to > ~1.2 terrabyte of SATA disks (4x Maxtor 500GB 7200 RPM disks w/RAID5 > config). Any suggestions? Up the # of spindles? :) -- Mike Horwath, reachable via drechsau@Geeks.ORG From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 02:31:03 2006 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 0587116A4DE for ; Thu, 6 Jul 2006 02:31:03 +0000 (UTC) (envelope-from sean@sean.gigave.com) Received: from mailhost.gigavenue.com (mailhost.gigavenue.com [208.66.96.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id 87E0543D46 for ; Thu, 6 Jul 2006 02:31:02 +0000 (GMT) (envelope-from sean@sean.gigave.com) Received: from sean.gigave.com (office.gigavenue.com [208.66.96.66]) by mailhost.gigavenue.com (Postfix) with ESMTP id 28A1C924F1F; Thu, 6 Jul 2006 02:31:02 +0000 (UTC) Received: by sean.gigave.com (Postfix, from userid 501) id 103D5462BB9; Wed, 5 Jul 2006 19:31:02 -0700 (PDT) Date: Wed, 5 Jul 2006 19:31:01 -0700 From: Sean Chittenden To: "Derrick T. Woolworth" Message-ID: <20060706023101.GR17377@Hummer.local> References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> X-Mailman-Approved-At: Thu, 06 Jul 2006 02:33:14 +0000 Cc: freebsd-performance@freebsd.org Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 02:31:03 -0000 [ Trimmed to just performance@ since disk performance sizing seems to ] [ be a frequently hit upon topic recently. ] > I'm currently trying to build a moderate large system with 4 > presentation servers, 2 database servers and one large storage > system using NFS mapped to ~1.2 terrabyte of SATA disks (4x Maxtor > 500GB 7200 RPM disks w/RAID5 config). Any suggestions? *cough* 4x 50iops per SATA is about 200iops assuming 100% cache miss. Go with 8x 250GB drives instead or do something to increase your spindle count before you spend any time worrying about what SATA card you're using.... unless your disk set is going to fit inside of 64-128MB of RAM, at which point I'd suggest just increasing the number of nbufs instead of spending the bucks on a fancy SATA controller. What's your justification for this machine? Capacity, raw random IOps, or .... -sc -- Sean Chittenden From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 09:19:33 2006 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 085E816A4DA for ; Thu, 6 Jul 2006 09:19:33 +0000 (UTC) (envelope-from maamoo@gmail.com) Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 80C1743D49 for ; Thu, 6 Jul 2006 09:19:32 +0000 (GMT) (envelope-from maamoo@gmail.com) Received: by wx-out-0102.google.com with SMTP id h30so925594wxd for ; Thu, 06 Jul 2006 02:19:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=D3TUqwr+NUA3uMIvGm7h4ldrDhalMiq14g+i7AkaZWf7MWbecjeq0jsJBjfKyLrQ9ny7UVrNYAJU/zNrlGQZnzrVyYbnGqtMXOLfcwHjmo/DQIzuZMjAB/IyC2Rd8wdUT5Bv2+IB9BSveSpvsKihKkBLJLBLoLOyGmTVQHIValg= Received: by 10.70.30.7 with SMTP id d7mr7344101wxd; Thu, 06 Jul 2006 02:19:31 -0700 (PDT) Received: by 10.70.90.16 with HTTP; Thu, 6 Jul 2006 02:19:31 -0700 (PDT) Message-ID: Date: Thu, 6 Jul 2006 17:19:31 +0800 From: "S H A N" To: "Bryan Fullerton" In-Reply-To: MIME-Version: 1.0 References: <35de0c300606220613n44abe4ccy2d9a1670a1c6ee9c@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: performance@freebsd.org Subject: Re: Poor FreeBSD Performance under cacti/snmp usage when using remote shell 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: Thu, 06 Jul 2006 09:19:33 -0000 hi group, after knocking my head in vien i just upgraded the FreeBSD box from 6.0 to 6.1 and the problem is gone :-) best regards and thanks for your assistance!. From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 08:39:36 2006 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 66EB516A4DA; Thu, 6 Jul 2006 08:39:36 +0000 (UTC) (envelope-from bsam@ns.kfs.ru) Received: from ns.kfs.ru (kfs.kfs.ru [62.183.117.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id DEFEB43D45; Thu, 6 Jul 2006 08:39:35 +0000 (GMT) (envelope-from bsam@ns.kfs.ru) Received: from bsam by ns.kfs.ru with local (Exim 4.54 (FreeBSD)) id 1FyPOX-0006c1-Tj; Thu, 06 Jul 2006 12:39:33 +0400 To: "Derrick T. Woolworth" References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> From: Boris Samorodov Date: Thu, 06 Jul 2006 12:39:33 +0400 In-Reply-To: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> (Derrick T. Woolworth's message of "Wed, 5 Jul 2006 20:02:55 -0500") Message-ID: <83074666@serv3.int.kfs.ru> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.0.50 (berkeley-unix) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Sender: "Boris B. Samorodov" X-Mailman-Approved-At: Thu, 06 Jul 2006 11:54:57 +0000 Cc: freebsd-hackers@freebsd.org, freebsd-performance@freebsd.org, freebsd-questions@freebsd.org Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 08:39:36 -0000 On Wed, 5 Jul 2006 20:02:55 -0500 Derrick T. Woolworth wrote: > Has anyone had success with SATA300 controllers with FreeBSD 6.1? I've been > trying Promise and nVidia nForce4 and I'm not having any luck. Using a MSI I have an nForce4 built-in card on amd64 motherboard and use it as a testing machine with 6.1-STABLE/7.0-CURRENT amd64/i386 worlds. Everyting is fine so far (crossing fingers). > K8NGM2-L motherboard and others, but 6.1's installation hangs as soon as it > sees ad4. I've also tried using an Adaptec 1210SA controller and had zero > results. I've read that the chipset on this controller is not very good - > forces serialized access to the controller's channels??? Nevertheless, I've > got a K8N Diamond motherboard on a workstation and I was able to at least > "start" the 6.1 installation. I have no idea if its stable. At this point, > I'd settle for just knowing "which" SATA300 controller to use that will work > successfully and "well" with FreeBSD 6.0 OR 6.1. Another question, would I > have more success installing 6.0 and then upgrading the kernel and > recompiling with a build-world? > I'm currently trying to build a moderate large system with 4 presentation > servers, 2 database servers and one large storage system using NFS mapped to > ~1.2 terrabyte of SATA disks (4x Maxtor 500GB 7200 RPM disks w/RAID5 > config). Any suggestions? WBR -- Boris Samorodov (bsam) Research Engineer, http://www.ipt.ru Telephone & Internet SP FreeBSD committer, http://www.FreeBSD.org The Power To Serve From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 15:25:28 2006 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 9A3AF16A4DF; Thu, 6 Jul 2006 15:25:28 +0000 (UTC) (envelope-from ahebert@pubnix.net) Received: from mail.pubnix.net (Mail.pubnix.net [192.172.250.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id E87E343D55; Thu, 6 Jul 2006 15:25:27 +0000 (GMT) (envelope-from ahebert@pubnix.net) Received: from [10.0.1.2] (aal.pubnix.net [64.235.216.13]) (authenticated bits=0) by mail.pubnix.net (8.13.6/8.13.6) with ESMTP id k66FPP5F002963; Thu, 6 Jul 2006 11:25:26 -0400 (EDT) (envelope-from ahebert@pubnix.net) Message-ID: <44AD2B65.9080407@pubnix.net> Date: Thu, 06 Jul 2006 11:25:25 -0400 From: Alain Hebert Organization: PubNIX, Inc. User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.13) Gecko/20060514 X-Accept-Language: en-us, en MIME-Version: 1.0 References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> In-Reply-To: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Thu, 06 Jul 2006 15:48:30 +0000 Cc: freebsd-hackers@freebsd.org, freebsd-performance@freebsd.org, freebsd-questions@freebsd.org Subject: Re: SATA300 Controllers X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: ahebert@pubnix.net List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Jul 2006 15:25:28 -0000 Hi, I've been having the same issues. The conclusion of my testing is that type of card (aka Adaptec 1210SA, Promise PDC2* ) are not stable, reliable, performant. (For my taste btw) The underlying technology is just mickey mouse: They store the config on drive (ok); They dont accelerate mirror that much. (mirror function in driver); If you loose a drive your filesystem jam (since the mirror function is in the driver); You have to rebuilt via the bios (long downtime). The best card are the 3ware 9000/9500 series. Which is a real hard implementation. FYI: I have both success with Marvell 88SX5041 SATA150 and Promise PDC20378 SATA150. I had major failure under load with Adaptec 1210SA and Promise TX2300. Good luck. Derrick T. Woolworth wrote: > Hello all, > > Sorry for cross-posting, but these issues seem relevant for lists... > > Has anyone had success with SATA300 controllers with FreeBSD 6.1? > I've been > trying Promise and nVidia nForce4 and I'm not having any luck. Using > a MSI > K8NGM2-L motherboard and others, but 6.1's installation hangs as soon > as it > sees ad4. I've also tried using an Adaptec 1210SA controller and had > zero > results. I've read that the chipset on this controller is not very > good - > forces serialized access to the controller's channels??? > Nevertheless, I've > got a K8N Diamond motherboard on a workstation and I was able to at least > "start" the 6.1 installation. I have no idea if its stable. At this > point, > I'd settle for just knowing "which" SATA300 controller to use that > will work > successfully and "well" with FreeBSD 6.0 OR 6.1. Another question, > would I > have more success installing 6.0 and then upgrading the kernel and > recompiling with a build-world? > > I'm currently trying to build a moderate large system with 4 presentation > servers, 2 database servers and one large storage system using NFS > mapped to > ~1.2 terrabyte of SATA disks (4x Maxtor 500GB 7200 RPM disks w/RAID5 > config). Any suggestions? > > Thanks, > > Derrick > _______________________________________________ > freebsd-hackers@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to > "freebsd-hackers-unsubscribe@freebsd.org" > -- Alain Hebert ahebert@pubnix.net PubNIX Inc. P.O. Box 175 Beaconsfield, Quebec H9W 5T7 tel 514-990-5911 http://www.pubnix.net fax 514-990-9443 From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 19:55:20 2006 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 8427616A4F6; Thu, 6 Jul 2006 19:55:20 +0000 (UTC) (envelope-from wb@freebie.xs4all.nl) Received: from smtp-vbr3.xs4all.nl (smtp-vbr3.xs4all.nl [194.109.24.23]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9A08243D68; Thu, 6 Jul 2006 19:55:10 +0000 (GMT) (envelope-from wb@freebie.xs4all.nl) Received: from freebie.xs4all.nl (freebie.xs4all.nl [213.84.32.253]) by smtp-vbr3.xs4all.nl (8.13.6/8.13.6) with ESMTP id k66Jt6dC021133; Thu, 6 Jul 2006 21:55:06 +0200 (CEST) (envelope-from wb@freebie.xs4all.nl) Received: from freebie.xs4all.nl (localhost [127.0.0.1]) by freebie.xs4all.nl (8.13.6/8.13.3) with ESMTP id k66Jt4K4001336; Thu, 6 Jul 2006 21:55:04 +0200 (CEST) (envelope-from wb@freebie.xs4all.nl) Received: (from wb@localhost) by freebie.xs4all.nl (8.13.6/8.13.6/Submit) id k66Jt4RU001335; Thu, 6 Jul 2006 21:55:04 +0200 (CEST) (envelope-from wb) Date: Thu, 6 Jul 2006 21:55:04 +0200 From: Wilko Bulte To: "Derrick T. Woolworth" Message-ID: <20060706195504.GA1252@freebie.xs4all.nl> References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by XS4ALL Virus Scanner X-Mailman-Approved-At: Thu, 06 Jul 2006 21:07:21 +0000 Cc: freebsd-hackers@freebsd.org, freebsd-performance@freebsd.org, freebsd-questions@freebsd.org Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 19:55:20 -0000 On Wed, Jul 05, 2006 at 08:02:55PM -0500, Derrick T. Woolworth wrote.. > Hello all, > > Sorry for cross-posting, but these issues seem relevant for lists... > > Has anyone had success with SATA300 controllers with FreeBSD 6.1? I've been > trying Promise and nVidia nForce4 and I'm not having any luck. Using a MSI > K8NGM2-L motherboard and others, but 6.1's installation hangs as soon as it > sees ad4. I've also tried using an Adaptec 1210SA controller and had zero Well, just as a datapoint this works fine for me: wb@freebie ~: dmesg|grep -i Prom atapci0: port 0xd480-0xd4ff,0xd000-0xd0ff mem 0xf7ff6000-0xf7ff6fff,0xf7fa0000-0xf7fbffff irq 21 at device 13.0 on pci2 ar0: 238475MB status: READY wb@freebie ~: uname -a FreeBSD freebie.xs4all.nl 6.1-STABLE FreeBSD 6.1-STABLE #2: Wed Jun 14 22:01:33 CEST 2006 root@freebie.xs4all.nl:/usr/obj/usr/src/sys/FREEBIE i386 -- Wilko Bulte wilko@FreeBSD.org From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 21:26:41 2006 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 5C82E16A504; Thu, 6 Jul 2006 21:26:41 +0000 (UTC) (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 9123A43D45; Thu, 6 Jul 2006 21:26:37 +0000 (GMT) (envelope-from scottl@samsco.org) Received: from [10.10.3.185] ([69.15.205.254]) (authenticated bits=0) by pooker.samsco.org (8.13.4/8.13.4) with ESMTP id k66LQNiH022282; Thu, 6 Jul 2006 15:26:29 -0600 (MDT) (envelope-from scottl@samsco.org) Message-ID: <44AD7FF9.8010405@samsco.org> Date: Thu, 06 Jul 2006 15:26:17 -0600 From: Scott Long User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.12) Gecko/20060206 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Wilko Bulte References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> <20060706195504.GA1252@freebie.xs4all.nl> In-Reply-To: <20060706195504.GA1252@freebie.xs4all.nl> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, score=0.0 required=3.8 tests=none autolearn=failed version=3.1.1 X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on pooker.samsco.org Cc: freebsd-hackers@freebsd.org, freebsd-performance@freebsd.org, freebsd-questions@freebsd.org, "Derrick T. Woolworth" Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 21:26:41 -0000 Wilko Bulte wrote: > On Wed, Jul 05, 2006 at 08:02:55PM -0500, Derrick T. Woolworth wrote.. > >>Hello all, >> >>Sorry for cross-posting, but these issues seem relevant for lists... >> >>Has anyone had success with SATA300 controllers with FreeBSD 6.1? I've been >>trying Promise and nVidia nForce4 and I'm not having any luck. Using a MSI >>K8NGM2-L motherboard and others, but 6.1's installation hangs as soon as it >>sees ad4. I've also tried using an Adaptec 1210SA controller and had zero > > > Well, just as a datapoint this works fine for me: > > wb@freebie ~: dmesg|grep -i Prom > atapci0: port > 0xd480-0xd4ff,0xd000-0xd0ff mem 0xf7ff6000-0xf7ff6fff,0xf7fa0000-0xf7fbffff > irq 21 at device 13.0 on pci2 > ar0: 238475MB status: READY > wb@freebie ~: uname -a > FreeBSD freebie.xs4all.nl 6.1-STABLE FreeBSD 6.1-STABLE #2: Wed Jun 14 > 22:01:33 CEST 2006 root@freebie.xs4all.nl:/usr/obj/usr/src/sys/FREEBIE > i386 > Promise has a good relationship with FreeBSD, I would expect their controllers to work pretty well. Scott From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 21:36:08 2006 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 8C12916A589; Thu, 6 Jul 2006 21:36:08 +0000 (UTC) (envelope-from mikej@rogers.com) Received: from H43.C18.B96.tor.eicat.ca (H43.C18.B96.tor.eicat.ca [66.96.18.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id 25DC943D46; Thu, 6 Jul 2006 21:36:05 +0000 (GMT) (envelope-from mikej@rogers.com) Received: from [127.0.0.1] (desktop.home.local [172.16.0.200]) by H43.C18.B96.tor.eicat.ca (Postfix) with ESMTP id 84C7D1144F; Thu, 6 Jul 2006 17:35:27 -0400 (EDT) Message-ID: <44AD8253.80702@rogers.com> Date: Thu, 06 Jul 2006 17:36:19 -0400 From: Mike Jakubik User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: "Derrick T. Woolworth" References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> In-Reply-To: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SpamToaster-Information: This messages has been scanned by SpamToaster http://www.digitalprogression.ca X-SpamToaster: Found to be clean X-SpamToaster-SpamCheck: not spam, SpamAssassin (not cached, score=-2.49, required 3.5, ALL_TRUSTED -1.80, BAYES_00 -2.60, DK_POLICY_SIGNSOME 0.00, DNS_FROM_RFC_ABUSE 0.20, DNS_FROM_RFC_POST 1.71) X-SpamToaster-From: mikej@rogers.com X-Spam-Status: No Cc: freebsd-hackers@freebsd.org, freebsd-performance@freebsd.org, freebsd-questions@freebsd.org Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 21:36:08 -0000 Derrick T. Woolworth wrote: > Hello all, > > Sorry for cross-posting, but these issues seem relevant for lists... > > Has anyone had success with SATA300 controllers with FreeBSD 6.1? > I've been > trying Promise and nVidia nForce4 and I'm not having any luck. Using > a MSI Yes, this chipset works well for me. --- atapci0: port 0x3040-0x3047,0x3034-0x3037,0x3038-0x303f,0x3030-0x3033,0x3020-0x302f mem 0xed000000-0xed0003ff irq 19 at device 31.2 on pci0 ad4: 152627MB at ata2-master SATA300 GEOM_MIRROR: Device gm created (id=1306182778). GEOM_MIRROR: Device gm: provider ad4 detected. ad6: 152627MB at ata3-master SATA300 SMP: AP CPU #1 Launched! GEOM_MIRROR: Device gm: provider ad6 detected. GEOM_MIRROR: Device gm: provider ad6 activated. GEOM_MIRROR: Device gm: provider ad4 activated. GEOM_MIRROR: Device gm: provider mirror/gm launched. --- For a simple RAID such as mirroring, i strongly suggest you stay away from cheap/onboard RAID solutions, and use gmirror instead. From owner-freebsd-performance@FreeBSD.ORG Thu Jul 6 22:10:48 2006 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 272A816A4DA; Thu, 6 Jul 2006 22:10:48 +0000 (UTC) (envelope-from wb@freebie.xs4all.nl) Received: from smtp-vbr8.xs4all.nl (smtp-vbr8.xs4all.nl [194.109.24.28]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4787143D45; Thu, 6 Jul 2006 22:10:46 +0000 (GMT) (envelope-from wb@freebie.xs4all.nl) Received: from freebie.xs4all.nl (freebie.xs4all.nl [213.84.32.253]) by smtp-vbr8.xs4all.nl (8.13.6/8.13.6) with ESMTP id k66MAeov023809; Fri, 7 Jul 2006 00:10:45 +0200 (CEST) (envelope-from wb@freebie.xs4all.nl) Received: from freebie.xs4all.nl (localhost [127.0.0.1]) by freebie.xs4all.nl (8.13.6/8.13.3) with ESMTP id k66MAeVH003601; Fri, 7 Jul 2006 00:10:40 +0200 (CEST) (envelope-from wb@freebie.xs4all.nl) Received: (from wb@localhost) by freebie.xs4all.nl (8.13.6/8.13.6/Submit) id k66MAe6x003600; Fri, 7 Jul 2006 00:10:40 +0200 (CEST) (envelope-from wb) Date: Fri, 7 Jul 2006 00:10:40 +0200 From: Wilko Bulte To: Scott Long Message-ID: <20060706221039.GA3579@freebie.xs4all.nl> References: <10fd06c60607051802jd9d6158ufd3406465cc64dfc@mail.gmail.com> <20060706195504.GA1252@freebie.xs4all.nl> <44AD7FF9.8010405@samsco.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44AD7FF9.8010405@samsco.org> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by XS4ALL Virus Scanner X-Mailman-Approved-At: Thu, 06 Jul 2006 22:24:07 +0000 Cc: freebsd-hackers@FreeBSD.ORG, freebsd-performance@FreeBSD.ORG, freebsd-questions@FreeBSD.ORG, "Derrick T. Woolworth" Subject: Re: SATA300 Controllers 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: Thu, 06 Jul 2006 22:10:48 -0000 On Thu, Jul 06, 2006 at 03:26:17PM -0600, Scott Long wrote.. > Wilko Bulte wrote: > >On Wed, Jul 05, 2006 at 08:02:55PM -0500, Derrick T. Woolworth wrote.. > > > >>Hello all, > >> > >>Sorry for cross-posting, but these issues seem relevant for lists... > >> > >>Has anyone had success with SATA300 controllers with FreeBSD 6.1? I've > >>been > >>trying Promise and nVidia nForce4 and I'm not having any luck. Using a > >>MSI > >>K8NGM2-L motherboard and others, but 6.1's installation hangs as soon as > >>it > >>sees ad4. I've also tried using an Adaptec 1210SA controller and had zero > > > > > >Well, just as a datapoint this works fine for me: > > > >wb@freebie ~: dmesg|grep -i Prom > >atapci0: port > >0xd480-0xd4ff,0xd000-0xd0ff mem 0xf7ff6000-0xf7ff6fff,0xf7fa0000-0xf7fbffff > >irq 21 at device 13.0 on pci2 > >ar0: 238475MB status: READY > >wb@freebie ~: uname -a > >FreeBSD freebie.xs4all.nl 6.1-STABLE FreeBSD 6.1-STABLE #2: Wed Jun 14 > >22:01:33 CEST 2006 root@freebie.xs4all.nl:/usr/obj/usr/src/sys/FREEBIE > >i386 > > > > Promise has a good relationship with FreeBSD, I would expect their > controllers to work pretty well. Yup. I cleared this TX2200 (IIRC) card with Soren first before I ordered it. It only has SATA150 disks connected to it though, I do not own SATA300 drives. All in all the whole thing works fine for me. -- Wilko Bulte wilko@FreeBSD.org