From owner-freebsd-questions@FreeBSD.ORG Fri Jan 27 20:15:13 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 D64C416A420 for ; Fri, 27 Jan 2006 20:15:13 +0000 (GMT) (envelope-from romeotheriault@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id 178A743D5E for ; Fri, 27 Jan 2006 20:15:09 +0000 (GMT) (envelope-from romeotheriault@gmail.com) Received: by wproxy.gmail.com with SMTP id i5so736867wra for ; Fri, 27 Jan 2006 12:15:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:mime-version:content-transfer-encoding:message-id:content-type:to:from:subject:date:x-mailer; b=A0LrssyTwKY8SeAuWEmfs2iyEydNIZIlAi+hryp/G/MA1UWiIEarS6KiR66Azi81kTjVcaSQD6gHo8aej/m8KOkENMheH70m8Pc8R1cN9qXEbQ3ic87595SOCktQq2KR/Woq+QUR3Io6NINiR7Dw+nEexL3qwNjRA6NVHR2M7/M= Received: by 10.54.62.2 with SMTP id k2mr504529wra; Fri, 27 Jan 2006 12:15:09 -0800 (PST) Received: from ?130.111.68.145? ( [130.111.68.145]) by mx.gmail.com with ESMTP id 11sm6350651wrl.2006.01.27.12.15.07; Fri, 27 Jan 2006 12:15:07 -0800 (PST) Mime-Version: 1.0 (Apple Message framework v746.2) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: freebsd-questions@freebsd.org From: Romeo Theriault Date: Fri, 27 Jan 2006 15:15:05 -0500 X-Mailer: Apple Mail (2.746.2) Subject: 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: Fri, 27 Jan 2006 20:15:13 -0000 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. 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 #use the TSC timecounter #use the libthr threading library with mysql #and it seems mysql 4.x has better performance than 5.x under Freebsd 6. Here are some websites that I found useful with this: http://wikitest.freebsd.org/moin.cgi/MySQL http://www.unixguide.net/freebsd/faq/05.26.shtml http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2005-12/ msg00078.html http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2005-12/ msg00084.html http://lists.freebsd.org/pipermail/freebsd-performance/2005-December/ 001677.html http://taosecurity.blogspot.com/2005/11/problems-with-freebsd-6.html http://blog.gslin.org/archives/2005/12/12/252/ Hopefully this helps someone else out. Romeo