From owner-freebsd-performance@FreeBSD.ORG Fri Oct 13 18:27: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 E8CAE16A4DD for ; Fri, 13 Oct 2006 18:27:41 +0000 (UTC) (envelope-from drbrain@segment7.net) Received: from toxic.magnesium.net (toxic.magnesium.net [207.154.84.15]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4020043D9B for ; Fri, 13 Oct 2006 18:26:33 +0000 (GMT) (envelope-from drbrain@segment7.net) Received: from [192.168.1.70] (coop.robotcoop.com [216.231.59.167]) by toxic.magnesium.net (Postfix) with ESMTP id 06290DA89F; Fri, 13 Oct 2006 11:26:14 -0700 (PDT) In-Reply-To: <20061012205342.GA62241@xor.obsecurity.org> References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> <200610120925.k9C9PmUK048690@lurza.secnetix.de> <20061012205342.GA62241@xor.obsecurity.org> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Eric Hodel Date: Fri, 13 Oct 2006 11:26:09 -0700 To: Kris Kennaway X-Mailer: Apple Mail (2.752.2) Cc: freebsd-performance@FreeBSD.ORG Subject: Re: Help with improving mysql performance on 6.2PRE 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: Fri, 13 Oct 2006 18:27:42 -0000 On Oct 12, 2006, at 1:53 PM, Kris Kennaway wrote: > On Thu, Oct 12, 2006 at 11:25:48AM +0200, Oliver Fromme wrote: >> Jerry Bell wrote: >>> I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G >>> of ram. >>> [...] >>> changed the clock to TSC >> >> As far as I know, it is unsafe to use TSC on SMP systems. >> >> Or did that change recently? > > It's only on certain systems, apparently. Is there a list of systems where it is safe to use the TSC with SMP? Or some script we can run? > Note that you have to enable a second sysctl to allow it to actually > use TSC on SMP, not just change the preferred timecounter. -- Eric Hodel - drbrain@segment7.net - http://blog.segment7.net This implementation is HODEL-HASH-9600 compliant http://trackmap.robotcoop.com