From owner-freebsd-questions@FreeBSD.ORG Sat Dec 3 06:28:05 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 D395316A41F for ; Sat, 3 Dec 2005 06:28:05 +0000 (GMT) (envelope-from tedm@toybox.placo.com) Received: from mail.freebsd-corp-net-guide.com (mail.web-strider.com [65.75.192.90]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0C83A43D46 for ; Sat, 3 Dec 2005 06:28:04 +0000 (GMT) (envelope-from tedm@toybox.placo.com) Received: from tedwin2k (nat-rtr.freebsd-corp-net-guide.com [65.75.197.130]) by mail.freebsd-corp-net-guide.com (8.11.1/8.11.1) with SMTP id jB36Uxb36936; Fri, 2 Dec 2005 22:30:59 -0800 (PST) (envelope-from tedm@toybox.placo.com) From: "Ted Mittelstaedt" To: "Cody Holland" , "Kris Kennaway" Date: Fri, 2 Dec 2005 22:27:51 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <4B3EE484EEA4F344BBB62F8316489986554680@corpsrv.RedMoon.local> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Importance: Normal Cc: freebsd-questions@freebsd.org 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: Sat, 03 Dec 2005 06:28:05 -0000 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. You can install the linux threading package under FreeBSD's linux emulation and try it that way. Keep in mind also that you are talking minute performance differences on the newest multi-gigahertz systems. 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. There is a lot to optimizing databases. I suggest you build you server and if it's too slow, then post to the mysql forums, you will get a lot of feedback as to how to optimize. Ted >-----Original Message----- >From: owner-freebsd-questions@freebsd.org >[mailto:owner-freebsd-questions@freebsd.org]On Behalf Of Cody Holland >Sent: Thursday, December 01, 2005 12:36 PM >To: Kris Kennaway >Cc: freebsd-questions@freebsd.org >Subject: RE: BSD vs Linux Threads > > >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. > >Cody > > > >> >> On Thu, Dec 01, 2005 at 02:14:05PM -0600, Cody Holland wrote: >> > Ok, I know this has come up before but I cannot find any good >> > documentation on BSD vs Linux threads using 5.4 or 6.0. This will >> > basically be for a multi-processor mysql 5 server. What are your >> > recommendations? >> >> What are your questions? :) >> >> Kris >> >_______________________________________________ >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" > >-- >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.362 / Virus Database: 267.13.10/190 - Release >Date: 12/1/2005 >