From owner-freebsd-questions@FreeBSD.ORG Fri Dec 9 01:20:06 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 05F7A16A423 for ; Fri, 9 Dec 2005 01:20:06 +0000 (GMT) (envelope-from grog@lemis.com) Received: from ext-gw.lemis.com (ext-gw.lemis.com [150.101.14.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id C5D2443D8A for ; Fri, 9 Dec 2005 01:19:40 +0000 (GMT) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by ext-gw.lemis.com (Postfix) with ESMTP id A69D0131D43; Fri, 9 Dec 2005 11:49:22 +1030 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id E4762857BE; Fri, 9 Dec 2005 11:50:22 +1030 (CST) Date: Fri, 9 Dec 2005 11:50:22 +1030 From: Greg 'groggy' Lehey To: Ted Mittelstaedt Message-ID: <20051209012022.GE80362@wantadilla.lemis.com> References: <4B3EE484EEA4F344BBB62F8316489986554680@corpsrv.RedMoon.local> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="WBsA/oQW3eTA3LlM" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: freebsd-questions@freebsd.org, Cody Holland , Kris Kennaway Subject: Re: BSD vs Linux Threads 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, 09 Dec 2005 01:20:06 -0000 --WBsA/oQW3eTA3LlM Content-Type: text/plain; charset=us-ascii Content-Disposition: inline [resequenced] On Friday, 2 December 2005 at 22:27:51 -0800, Ted Mittelstaedt wrote: > On Thursday, December 01, 2005 12:36 PM, Cody Holland wrote: >> >> Well in the past it was stated that on a MySQL server installed using >> Linux threads was faster than using the native BSD threads. I'm in the >> process of building a new MySQL 5 server with FreeBSD 5.4 and was >> wanting to know if using the Linux threads was still faster. > > It probably is because mysql is optimized for the Linux threading > implementation. > Also keep in mind that freebsd filesystems are mounted async by default, > not sync by default like Linux, as a result FreeBSD always does worse > in these stupid bakeoffs you read about in the trade rags. Somebody else has pointed out that this was stated the wrong way round. But what we've seen so far is probably not related to the way the file systems are mounted. > You can install the linux threading package under FreeBSD's linux > emulation and try it that way. I don't think this is a useful option. Linuxthreads might be, though. > Keep in mind also that you are talking minute performance > differences on the newest multi-gigahertz systems. It would be nice if this were true. We've seen claims of performance differences in the order of 3:1. > Furthermore I will point out that unless your database is smaller > than physical memory of the server, then the argument between mysql > threading and non-threading is a completely moot issue since the > hits to the disk will be the bottleneck. Many database systems are CPU-bound. MySQL has identified that there are some serious issues with FreeBSD at the moment. As somebody with a foot in both camps, I'm keeping an open mind about where the problem is, but certainly the threading libraries are an issue. I wish I could make a specific recommendation. Greg -- When replying to this message, please take care not to mutilate the original text. For more information, see http://www.lemis.com/email.html See complete headers for address and phone numbers. --WBsA/oQW3eTA3LlM Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDmNvWIubykFB6QiMRAuhUAKCe/CHK7wwLuWet/RggWp2WQ9sfDQCfYdS+ 7P6T6fOnVfffnbQ3aGKMWk0= =4R/T -----END PGP SIGNATURE----- --WBsA/oQW3eTA3LlM--