Re: BSD vs Linux Threads
On 12/9/05, Greg 'groggy' Lehey <[EMAIL PROTECTED]> wrote: > > [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. Well yes they are, normally due to poor or zero tuning of the queries etctuning RDBMS's is a science in itself andcan be quite specific tothe RDBMS in question 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. COuld well be that the mysql is optimised for lunix threading. Given it also run on Solaris etc I wonder it performs on the tradition commericial Unix variants? -- martin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: BSD vs Linux Threads
>-Original Message- >From: Greg 'groggy' Lehey [mailto:[EMAIL PROTECTED] >Sent: Thursday, December 08, 2005 5:20 PM >To: Ted Mittelstaedt >Cc: Cody Holland; Kris Kennaway; freebsd-questions@FreeBSD.org >Subject: Re: BSD vs Linux Threads > > >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. > Postgres? Ted ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
[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. pgpXUotNG3Ncf.pgp Description: PGP signature
Re: BSD vs Linux Threads
Michael Vince wrote: Giorgos Keramidas wrote: On 2005-12-02 14:00, Michael Vince <[EMAIL PROTECTED]> wrote: For 6 Linux threads from my benchmarking and from what I have seen some peoples posts gives poor performance compared to libthr or libpthread I am using more of libthr over libpthread in 6.0 and have been benchmarking best results. Try this in /etc/libmap.conf [mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so Unfortunately, "I have best results with libthr" is completely worthless, unless you also describe the exact process of the benchmark and why this particular benchmark is considered very important for your specific application vs. other types of workload :/ OK well to put it in another way libthr has beaten libpthread (and everything else you can do in FreeBSD such as linux threads) in ANY MySQL benchmark test I have done. And just to add to that I have probably spent about 20 hours at least worth of benchmarking MySQL. Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
Giorgos Keramidas wrote: On 2005-12-02 14:00, Michael Vince <[EMAIL PROTECTED]> wrote: For 6 Linux threads from my benchmarking and from what I have seen some peoples posts gives poor performance compared to libthr or libpthread I am using more of libthr over libpthread in 6.0 and have been benchmarking best results. Try this in /etc/libmap.conf [mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so Unfortunately, "I have best results with libthr" is completely worthless, unless you also describe the exact process of the benchmark and why this particular benchmark is considered very important for your specific application vs. other types of workload :/ OK well to put it in another way libthr has beaten libpthread (and everything else you can do in FreeBSD such as linux threads) in ANY MySQL benchmark test I have done. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: BSD vs Linux Threads
>-Original Message- >From: Chad Leigh -- Shire.Net LLC [mailto:[EMAIL PROTECTED] >Sent: Friday, December 02, 2005 11:15 PM >To: Ted Mittelstaedt >Subject: Re: BSD vs Linux Threads > > >sent offlist so that you can fix it yourself (if indeed I am right, >which is not guaranteed :-) ) > >On Dec 2, 2005, at 11:27 PM, Ted Mittelstaedt wrote: > >> 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. > >Don't you mean just the opposite -- linux mounts by default asynch >and BSD synch so that the BSD is "disadvantaged"? > Oops, your right. Disadvantaged by speed of course - but if your server crashes, you won't think FreeBSD is disadvantaged. Ted ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
RE: BSD vs Linux Threads
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: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] 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 >"[EMAIL PROTECTED]" > >-- >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 > ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
On 2005-12-02 14:00, Michael Vince <[EMAIL PROTECTED]> wrote: > For 6 Linux threads from my benchmarking and from what I have seen > some peoples posts gives poor performance compared to libthr or > libpthread I am using more of libthr over libpthread in 6.0 and have > been benchmarking best results. > > Try this in /etc/libmap.conf > [mysqld] > libpthread.so.2 libthr.so.2 > libpthread.so libthr.so Unfortunately, "I have best results with libthr" is completely worthless, unless you also describe the exact process of the benchmark and why this particular benchmark is considered very important for your specific application vs. other types of workload :/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
For 6 Linux threads from my benchmarking and from what I have seen some peoples posts gives poor performance compared to libthr or libpthread I am using more of libthr over libpthread in 6.0 and have been benchmarking best results. Try this in /etc/libmap.conf [mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so Mike 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? Thanks, Cody ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]" ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
On 12/2/05, Cody Holland <[EMAIL PROTECTED]> 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. I think this has been around the bends a bit, and people might be reluctant to start on it again. The best thing is to look through the archives, and also run some tests if you have the time and resources. Having said that hopefully you will get some helpful feedback on this thread. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
On Thu, Dec 01, 2005 at 02:36:19PM -0600, 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. I don't think so, but feel free to benchmark and let us know :) Kris pgpTm15AEpvz9.pgp Description: PGP signature
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 "[EMAIL PROTECTED]"
Re: BSD vs Linux Threads
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 pgp3epjKKM08d.pgp Description: PGP signature
BSD vs Linux Threads
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? Thanks, Cody ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"