From owner-freebsd-threads@FreeBSD.ORG Sat May 22 05:45:40 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E90E216A4CE for ; Sat, 22 May 2004 05:45:40 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id DD85D43D39 for ; Sat, 22 May 2004 05:45:40 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 98888 invoked by uid 89); 22 May 2004 12:49:39 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 22 May 2004 12:49:39 -0000 Message-Id: <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Sat, 22 May 2004 05:45:20 -0700 To: freebsd-threads@freebsd.org From: JG In-Reply-To: <40AEFA5E.7060603@he.iki.fi> References: <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: Re: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 22 May 2004 12:45:41 -0000 At 09:59 AM 5/22/2004 +0300, you wrote: >JG wrote: > >> >> >>Do you have any suggestions or ideas as to what the problem is? > >I failed to find benchmark numbers using libpthread or libthr. Did you >have some and I just missed them? > >Pete Pete, 90% of the benchmarks I did were done with libptherads. I haven't personally tested with libthr, but others have and their results were poor as well. I wanted to avoid reposting pages of benchmarks, but I guess it's not going to happen. I'll start posting mine here here soon, I'm going to retest everything local with super-smack and run-all-tests today. You can also see Mikes run-all-tests benchmarks here: http://mikehost.com/~mike/tmp/bench.htm Here is a quote from an email Chris Elsworth sent me: "Just had a read through the web archive, all seems very familiar :) A colleague and I spent hours fiddling with the various threading libraries; kse, libc_r, libthr, linuxthreads I think were the main ones - I mostly tweaked MySQL, he tweaked the threading libraries, and nothing made any significant difference, so I'm not really convinced this is even a threading problem - I don't see why all the threading libraries we tried all struggle to outperform Linux's default configuration on the same hardware." Here is Chris Elsworths post to the MySQL general mailing list: http://lists.mysql.com/mysql/165908 Here is an article at 2cpu.com showing how Linux improved 20%: http://www.2cpu.com/articles/98_4.html ... But I wish I knew how he ran super-smack, those numbers are insane. And my original posts to the FreeBSD AMD64 list are here: http://lists.freebsd.org/pipermail/freebsd-amd64/2004-May/ Scroll down to: "Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64? A lot of top posts so it got broken up a few times. -----------------------------------------------------------------------------------------------