From owner-freebsd-questions@FreeBSD.ORG  Fri Mar 20 17:57:39 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 8F57B106564A
	for <freebsd-questions@freebsd.org>;
	Fri, 20 Mar 2009 17:57:39 +0000 (UTC) (envelope-from matt@atopia.net)
Received: from pluto.atopia.net (pluto.atopia.net [67.222.134.90])
	by mx1.freebsd.org (Postfix) with ESMTP id 740238FC23
	for <freebsd-questions@freebsd.org>;
	Fri, 20 Mar 2009 17:57:39 +0000 (UTC) (envelope-from matt@atopia.net)
Received: by pluto.atopia.net (Postfix, from userid 1003)
	id 42D9D228E2; Fri, 20 Mar 2009 13:38:27 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by pluto.atopia.net (Postfix) with ESMTP id 41E51228AD
	for <freebsd-questions@freebsd.org>;
	Fri, 20 Mar 2009 13:38:27 -0400 (EDT)
Date: Fri, 20 Mar 2009 13:38:27 -0400 (EDT)
From: Matt Juszczak <matt@atopia.net>
To: freebsd-questions@freebsd.org
Message-ID: <alpine.BSF.2.00.0903201338190.29988@pluto.atopia.net>
User-Agent: Alpine 2.00 (BSF 1167 2008-08-23)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Subject: MySQL 5.0 on FreeBSD 7
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 20 Mar 2009 17:57:39 -0000

Hi all,

About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit).  I 
read at the time that the use of pthreads with FreeBSD would significantly 
improve performance, but as I was running the 64 bit version of FreeBSD, I 
could not use them.

Fast forward to today - a different setup and new opportunity has allowed 
me to research this combination again.  This time, some reading I have 
done on the use of FreeBSD 7 with MySQL has shown significant performance 
increases, but none of them really mention in detail how MySQL was setup.

I decided to install a 64 bit version of FreeBSD 7.x (to address the 8 GB 
RAM in the box) and attempt to build with pthreads enabled, as well as a 
static build and optimized compiler options.  Once again, got the 
error/warning in ports that the linux pthreads only works with the i386 32 
bit setup.

So I'm wondering if anyone here has successfully seen a MySQL 5.x 
performance boost with FreeBSD 7 compared to that of FreeBSD 6 on a 64 bit 
architecture, and if so, what they did to enable that boost.

Thanks!

-Matt