From owner-freebsd-current@FreeBSD.ORG Mon Oct 31 18:35:01 2005 Return-Path: X-Original-To: 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 DABA216A41F; Mon, 31 Oct 2005 18:35:01 +0000 (GMT) (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 8E30643D5C; Mon, 31 Oct 2005 18:35:01 +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 3A68CDA8A0; Mon, 31 Oct 2005 10:35:01 -0800 (PST) In-Reply-To: <20051031171123.U80645@fledge.watson.org> References: <0E972CEE334BFE4291CD07E056C76ED808DC30A8@bragi.housing.ufl.edu> <20051031171123.U80645@fledge.watson.org> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Eric Hodel Date: Mon, 31 Oct 2005 10:34:55 -0800 To: current@FreeBSD.org X-Mailer: Apple Mail (2.734) Cc: Robert Watson Subject: Re: MySQL Performance 6.0rc1 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: Mon, 31 Oct 2005 18:35:02 -0000 On Oct 31, 2005, at 9:21 AM, Robert Watson wrote: > Well, I'm happy to do a bit of gathering of information. So far > the main two recommendations have been: > > - Look at time counting -- if TSC is safe for your host, it can > significantly improve performance. It seems that, from this thread: http://lists.freebsd.org/pipermail/freebsd-current/2004-August/ 034073.html The question "is my TSC safe?" has the same answer as "am I using SMP?" Is this correct? > - Use libthr in FreEBSD 6.x, or linuxthreads in earlier versions. > > - Make sure you're using UNIX domain sockets for local traffic. > > Any other things to add to the list? I've created a page here: > > http://wikitest.freebsd.org/moin.cgi/MySQL > > Eventually we might want to turn this into a more formal document. I can't seem to edit this page, even after logging in.. -- Eric Hodel - drbrain@segment7.net - http://segment7.net FEC2 57F1 D465 EB15 5D6E 7C11 332A 551C 796C 9F04