From owner-freebsd-questions@FreeBSD.ORG Wed Oct 5 01:03:27 2005 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 021BD16A41F; Wed, 5 Oct 2005 01:03:27 +0000 (GMT) (envelope-from nevans@talkpoint.com) Received: from relay.talkpoint.com (relay.talkpoint.com [204.141.15.158]) by mx1.FreeBSD.org (Postfix) with ESMTP id 92B3043D46; Wed, 5 Oct 2005 01:03:26 +0000 (GMT) (envelope-from nevans@talkpoint.com) Received: from ASSP-nospam ([127.0.0.1]) by relay.talkpoint.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 4 Oct 2005 21:03:25 -0400 Received: from 204.141.15.136 ([204.141.15.136] helo=postal.talkpoint.com) by ASSP-nospam ; 5 Oct 05 01:03:25 -0000 Received: by postal.talkpoint.com with Internet Mail Service (5.5.2653.19) id ; Tue, 4 Oct 2005 21:03:25 -0400 Message-ID: <294123FE9E76C34193EF7019BAAE4B2C124F36@postal.talkpoint.com> From: Nick Evans To: 'Peter Wemm' , freebsd-amd64@freebsd.org Date: Tue, 4 Oct 2005 21:03:20 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-OriginalArrivalTime: 05 Oct 2005 01:03:25.0506 (UTC) FILETIME=[96D16220:01C5C948] Cc: Olaf Greve , freebsd-questions@freebsd.org Subject: RE: Which MySQL version best to use and with/without linux thread s? 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: Wed, 05 Oct 2005 01:03:27 -0000 > -----Original Message----- > From: Peter Wemm [mailto:peter@wemm.org] > Sent: Tuesday, October 04, 2005 8:17 PM > To: freebsd-amd64@freebsd.org > Cc: Olaf Greve; amd64@freebsd.org; freebsd-questions@freebsd.org > Subject: Re: Which MySQL version best to use and with/without linux > threads? > > > 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 > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" I've been benchmarking this on a dual opteron 246 server. mysql 4.1.x and libthr worked on 5.4, but 6.0 was faster and libthr was definitely faster than pthreads. There's a thread about this on performance@. Nick