From owner-freebsd-questions@FreeBSD.ORG Sat Jan 28 01:24:11 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C3A9316A420 for ; Sat, 28 Jan 2006 01:24:11 +0000 (GMT) (envelope-from romeotheriault@gmail.com) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.207]) by mx1.FreeBSD.org (Postfix) with ESMTP id 17CF043D6B for ; Sat, 28 Jan 2006 01:24:01 +0000 (GMT) (envelope-from romeotheriault@gmail.com) Received: by xproxy.gmail.com with SMTP id s9so444065wxc for ; Fri, 27 Jan 2006 17:24:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:in-reply-to:references:mime-version:content-type:message-id:cc:content-transfer-encoding:from:subject:date:to:x-mailer; b=Idhl8c1GzMelEKpKvLm998gOb4s64yWnYxPftnbsC7o3z/s820/mO+POh5Js+pLc5y045eHTuX+yZCP6xplkWPQ3bNpIfG4/HnHGUTQr3as41sOh4BHOzQIz9nKo3JmdIcnJlqvUfJZpYXexPiBeE1a0EnRrShv+ppjL7oB8+xQ= Received: by 10.70.129.14 with SMTP id b14mr4183043wxd; Fri, 27 Jan 2006 17:24:00 -0800 (PST) Received: from ?192.168.0.3? ( [66.231.218.96]) by mx.gmail.com with ESMTP id i40sm4953280wxd.2006.01.27.17.23.58; Fri, 27 Jan 2006 17:23:59 -0800 (PST) In-Reply-To: <20060127202202.GA65737@xor.obsecurity.org> References: <20060127202202.GA65737@xor.obsecurity.org> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <5158A64C-2BD2-4B2F-8EAA-F32E510FFA06@gmail.com> Content-Transfer-Encoding: 7bit From: Romeo Theriault Date: Fri, 27 Jan 2006 20:28:44 -0500 To: Kris Kennaway X-Mailer: Apple Mail (2.746.2) Cc: freebsd-questions@freebsd.org Subject: Re: mysql - linuxthreads X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 28 Jan 2006 01:24:11 -0000 I didn't personally measure it, though someday I hope to be able to, but I did read in several places that using the ULE scheduler was the better choice to use with FreeBSD. Here are the links that are noteworthy: http://wikitest.freebsd.org/moin.cgi/MySQL http://blog.gslin.org/archives/2005/12/12/252/ Romeo On Jan 27, 2006, at 3:22 PM, Kris Kennaway wrote: > On Fri, Jan 27, 2006 at 03:15:05PM -0500, Romeo Theriault wrote: >> A week or so ago I wrote to the this list asking about Freebsd and >> Mysql, wondering if you still needed to compile Mysql with >> linuxthreads to get better performance under Freebsd 6. I didn't get >> much of a response so I looked around for the answer. I thought I'd >> write back to the mailing list to tell anyone interested what I >> found. > > Thanks, this is always useful! > >> In the Freebsd 6.0 is seems that to get the best MySQL performance >> you need to do a few things. >> #compile your kernel with the ULE scheduler > > I'd be inclined to doubt this..all my measurements show ULE is slower > than 4BSD except at negligible load. How did you measure it? > >> #use the TSC timecounter >> #use the libthr threading library with mysql > > You definitely want libthr. > > Kris