From owner-freebsd-amd64@FreeBSD.ORG Wed Oct 5 00:17:11 2005 Return-Path: X-Original-To: freebsd-amd64@freebsd.org Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 63B2616A41F; Wed, 5 Oct 2005 00:17:11 +0000 (GMT) (envelope-from peter@wemm.org) Received: from daintree.corp.yahoo.com (daintree.corp.yahoo.com [216.145.52.172]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2FD1143D46; Wed, 5 Oct 2005 00:17:11 +0000 (GMT) (envelope-from peter@wemm.org) Received: by daintree.corp.yahoo.com (Postfix, from userid 2154) id 0481019775; Tue, 4 Oct 2005 17:17:11 -0700 (PDT) From: Peter Wemm To: freebsd-amd64@freebsd.org Date: Tue, 4 Oct 2005 17:17:09 -0700 User-Agent: KMail/1.8.2 References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <433D3C12.6020104@axis.nl> In-Reply-To: <433D3C12.6020104@axis.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200510041717.10435.peter@wemm.org> Cc: amd64@freebsd.org, freebsd-questions@freebsd.org Subject: Re: Which MySQL version best to use and with/without linux threads? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Oct 2005 00:17:11 -0000 On Friday 30 September 2005 06:22 am, Olaf Greve wrote: > Then, I'm currently configuring a second beast, eehhhh, server. :) > Being an AMD-64 19" server, running FreeBSD 5.4-Release AMD64. On it, > I instinctively installed the latest MySQL 4.0.x version (being > 4.0.26) and it works flawlessly with the data from my current > production machine. The only problem is that linuxthreads doesn't exist on FreeBSD/amd64. You have to use one of the native thread libraries. Your choices on 5.4 are not that great. I'd suggest libthr on 6.0 as the closest match to linuxthreads, but I don't recall if it is available on 5.4. I have a feeling it isn't. I have a feeling your choices are libc_r or libpthread (kse). libpthread should smoke libc_r for disk IO performance in general. But modern libthr (on 6.0+) should give it a serious run for its money. -- Peter Wemm - peter@wemm.org; peter@FreeBSD.org; peter@yahoo-inc.com "All of this is for nothing if we don't go to the stars" - JMS/B5