Date: Fri, 2 Dec 2005 22:27:51 -0800 From: "Ted Mittelstaedt" <tedm@toybox.placo.com> To: "Cody Holland" <cholland@redmoonbroadband.com>, "Kris Kennaway" <kris@obsecurity.org> Cc: freebsd-questions@freebsd.org Subject: RE: BSD vs Linux Threads Message-ID: <LOBBIFDAGNMAMLGJJCKNOEOGFCAA.tedm@toybox.placo.com> In-Reply-To: <4B3EE484EEA4F344BBB62F8316489986554680@corpsrv.RedMoon.local>
next in thread | previous in thread | raw e-mail | index | archive | help
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 >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?LOBBIFDAGNMAMLGJJCKNOEOGFCAA.tedm>