From owner-freebsd-current@FreeBSD.ORG Thu Mar 30 06:46:50 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 115C416A400; Thu, 30 Mar 2006 06:46:50 +0000 (UTC) (envelope-from Matthew.Thyer@dsto.defence.gov.au) Received: from digger1.defence.gov.au (digger1.defence.gov.au [203.5.217.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 11CF443D5C; Thu, 30 Mar 2006 06:46:30 +0000 (GMT) (envelope-from Matthew.Thyer@dsto.defence.gov.au) Received: from ednmsw501.dsto.defence.gov.au (ednmsw501.dsto.defence.gov.au [131.185.2.150]) by digger1.defence.gov.au with ESMTP id k2U6iUu0001811; Thu, 30 Mar 2006 16:14:30 +0930 (CST) Received: from muttley.dsto.defence.gov.au (unverified) by ednmsw501.dsto.defence.gov.au (Content Technologies SMTPRS 4.3.17) with ESMTP id ; Thu, 30 Mar 2006 16:16:22 +0930 Received: from ednex510.dsto.defence.gov.au (ednex510.dsto.defence.gov.au [131.185.2.170]) by muttley.dsto.defence.gov.au (8.11.3/8.11.3) with ESMTP id k2U6hXp20440; Thu, 30 Mar 2006 16:13:33 +0930 (CST) Received: from ednex511.dsto.defence.gov.au ([131.185.2.171]) by ednex510.dsto.defence.gov.au with Microsoft SMTPSVC(6.0.3790.1830); Thu, 30 Mar 2006 16:13:33 +0930 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Thu, 30 Mar 2006 16:13:32 +0930 Message-ID: <07018E951F2FBF42B40B3D61086788344C1D9D@ednex511.dsto.defence.gov.au> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: RE: mysql performance test results under FreeBSD-7.0-CURRENT Thread-Index: AcZTw0p28B08za9bS3GxT3I5LlQQxQAARnBA From: "Thyer, Matthew" To: "Ganbold" , X-OriginalArrivalTime: 30 Mar 2006 06:43:33.0030 (UTC) FILETIME=[435A6C60:01C653C5] X-TM-AS-Product-Ver: SMEX-7.0.0.1345-3.52.1006-14353.000 X-TM-AS-Result: No--11.900000-8.000000-2 X-Mailman-Approved-At: Wed, 05 Apr 2006 12:18:01 +0000 Cc: jasone@freebsd.org, deischen@freebsd.org, phk@phk.freebsd.dk, 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:46:50 -0000 A couple of things I have noticed in the kernel messages: WARNING: WITNESS option enabled, expect reduced performance. 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. -----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=20 various scheduler and compile time options. It seems like mysql(BUILD_OPTIMIZED=3Dyes, BUILD_STATIC=3Dyes,=20 WITH_PROC_SCOPE_PTH=3Dyes)-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=20 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=20 (http://www.watson.org/~robert/freebsd/clock/)? Does CURRENT src tree=20 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=20 malloc options should try (jemalloc? phkmalloc?) What is the default=20 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"