From owner-freebsd-questions@FreeBSD.ORG Fri Mar 20 18:15:01 2009 Return-Path: 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 D7ECB1065670 for ; Fri, 20 Mar 2009 18:15:01 +0000 (UTC) (envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net) Received: from mail.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id A17898FC13 for ; Fri, 20 Mar 2009 18:15:01 +0000 (UTC) (envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net) Received: from smoochies.rachie.is-a-geek.net (smoochies.rachie.is-a-geek.net [192.168.1.50]) by mail.rachie.is-a-geek.net (Postfix) with ESMTP id C5CF7AFC1FE; Fri, 20 Mar 2009 10:15:00 -0800 (AKDT) Received: by smoochies.rachie.is-a-geek.net (Postfix, from userid 1003) id B6E228442B; Fri, 20 Mar 2009 10:15:00 -0800 (AKDT) From: Mel Flynn To: freebsd-questions@freebsd.org Date: Fri, 20 Mar 2009 10:15:00 -0800 User-Agent: KMail/1.11.0 (FreeBSD/8.0-CURRENT; KDE/4.2.0; i386; ; ) References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200903201015.00654.mel.flynn+fbsd.questions@mailing.thruhere.net> Cc: Matt Juszczak Subject: Re: MySQL 5.0 on FreeBSD 7 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, 20 Mar 2009 18:15:02 -0000 On Friday 20 March 2009 09:38:27 Matt Juszczak wrote: > 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. You're confusing linux-threads with pthreads. The performance boosts mentioned are done using the FreeBSD Posix threads ("pthreads") library, in FreeBSD 7.x they are implemented using libthr(3). The benchmarks also assume you are using SCHED_ULE, rather then SCHED_4BSD. Nothing should be configured if you run GENERIC later then 7.0-RELEASE. There are tips available here: http://people.freebsd.org/~kris/scaling/mysql.html -- Mel