From owner-freebsd-performance@FreeBSD.ORG Mon May 14 11:59:24 2007 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 9A5F216A400 for ; Mon, 14 May 2007 11:59:24 +0000 (UTC) (envelope-from killing@multiplay.co.uk) Received: from multiplay.co.uk (core6.multiplay.co.uk [85.236.96.23]) by mx1.freebsd.org (Postfix) with ESMTP id 2705C13C48C for ; Mon, 14 May 2007 11:59:23 +0000 (UTC) (envelope-from killing@multiplay.co.uk) X-Spam-Checker-Version: SpamAssassin 3.1.5 (2006-08-29) on core6.multiplay.co.uk X-Spam-Level: X-Spam-Status: No, score=-24.7 required=6.0 tests=BAYES_00, USER_IN_WHITELIST, USER_IN_WHITELIST_TO autolearn=ham version=3.1.5 Received: from r2d2 ([212.135.219.182]) by multiplay.co.uk (multiplay.co.uk [85.236.96.23]) (MDaemon PRO v9.5.4) with ESMTP id md50003818757.msg for ; Mon, 14 May 2007 12:55:03 +0100 Message-ID: <018401c7961e$b0732570$b6db87d4@multiplay.co.uk> From: "Steven Hartland" To: "Cheffo" , "Michael K. Smith - Adhost" References: <46443103.9010008@otel.net><17838240D9A5544AAA5FF95F8D52031602018EFA@ad-exh01.adhost.lan> <46483584.70608@FreeBSD-BG.org> Date: Mon, 14 May 2007 12:54:55 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="windows-1251"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-MDRemoteIP: 212.135.219.182 X-Return-Path: killing@multiplay.co.uk X-Envelope-From: killing@multiplay.co.uk X-MDaemon-Deliver-To: freebsd-performance@freebsd.org X-Spam-Processed: multiplay.co.uk, Mon, 14 May 2007 12:55:04 +0100 X-MDAV-Processed: multiplay.co.uk, Mon, 14 May 2007 12:55:07 +0100 Cc: freebsd-performance@freebsd.org, ivo tasev Subject: Re: 6.2 Stable + Mysql 5.0 poor performance 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, 14 May 2007 11:59:24 -0000 ----- Original Message ----- From: "Cheffo" > CPU: Intel(R) Xeon(R) CPU 5130 @ 2.00GHz (2002.99-MHz K8-class CPU) > avail memory = 8265285632 (7882 MB) > FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs > da0 at arcmsr0 bus 0 target 0 lun 0 > da0: Fixed Direct Access SCSI-5 device > da0: 166.666MB/s transfers (83.333MHz, offset 32, 16bit), Tagged Queueing Enabled > da0: 610351MB (1249999872 512 byte sectors: 255H 63S/T 77808C) > (RAID 10 4x160GB SATA) > FreeBSD tiger.cmotd.com 6.2-STABLE FreeBSD 6.2-STABLE #5: Mon May 14 17:12:39 EEST 2007 > root@tiger.cmotd.com:/usr/obj/usr/src/sys/CORE64-SMP amd64 > > 1)Default settings: > > select_index 20000 1 0 8075.95 > select_index 20000 1 0 8111.38 > select_index 20000 1 0 8329.87 > select_index 20000 1 0 8105.15 > select_index 20000 1 0 8108.48 > > 2)kern.timecounter.hardware: HPET -> TSC > > select_index 20000 1 0 8927.00 > select_index 20000 1 0 8978.22 > select_index 20000 1 0 9076.20 > select_index 20000 1 0 9043.15 > select_index 20000 1 0 9158.74 > > 3)Changing /etc/libmap.conf > > select_index 20000 0 0 35888.48 > select_index 20000 0 0 38044.08 > select_index 20000 0 0 37984.83 > select_index 20000 0 0 37763.64 > select_index 20000 0 0 37799.25 > > 4)cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/my.cnf > > select_index 20000 0 0 40816.66 > select_index 20000 0 0 39808.36 > select_index 20000 0 0 39508.28 > select_index 20000 0 0 38147.48 > select_index 20000 0 0 38002.08 This sparked me to test our machine here: CPU: Intel(R) Xeon(R) CPU X5355 @ 2.66GHz (2666.68-MHz K8-class CPU) real memory = 9395240960 (8960 MB) avail memory = 8295161856 (7910 MB) FreeBSD/SMP: Multiprocessor System Detected: 8 CPU da0 at arcmsr0 bus 0 target 0 lun 0 da0: Fixed Direct Access SCSI-5 device da0: 166.666MB/s transfers (83.333MHz, offset 32, 16bit), Tagged Queueing Enabled da0: 333785MB (683591680 512 byte sectors: 255H 63S/T 42551C) FreeBSD test 6.2-RELEASE-p3 FreeBSD 6.2-RELEASE-p3 #2: Thu Apr 26 15:20:20 BST 2007 root@test1:/usr/src/sys/amd64/compile/MPUK_SMP amd64 Using all the enhanced settings mentioned except TSC as it doesnt seem to apply even when set. select_index 200000 0 0 23990.95 select_index 200000 0 0 21578.29 select_index 200000 0 0 21342.61 select_index 200000 0 0 20808.31 select_index 200000 0 0 22401.80 So something very bad is happening here as with 21.28Ghz of CPU its scoring half that of your machine which only has 8Ghz. Is STABLE that much quicker than RELEASE? Regards Steve ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337 or return the E.mail to postmaster@multiplay.co.uk.