From owner-freebsd-threads@FreeBSD.ORG Sun May 23 10:24:16 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 5F4A816A4CE for ; Sun, 23 May 2004 10:24:16 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3C2E143D45 for ; Sun, 23 May 2004 10:24:16 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 54362 invoked by uid 89); 23 May 2004 17:28:46 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 23 May 2004 17:28:46 -0000 Message-Id: <5.2.0.9.2.20040523100537.014613a8@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Sun, 23 May 2004 10:24:18 -0700 To: freebsd-threads@freebsd.org From: JG In-Reply-To: References: <5.2.0.9.2.20040523084628.016296b0@mail.ojoink.com> 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: Sun, 23 May 2004 17:24:16 -0000 > >None consolidated in the same post with the same versions >of FreeBSD and mysql. Like I said before, there are a ton >of posts on amd64@ and some here on threads@. It would >help much if you were to summarize them on a web page so >that all of us don't have to go searching through all >the archives trying to do it ourselves. Good idea, I'll do that now. > The default configuration with >libpthread vs FreeBSD-linuxthreads seems to be similar. I would disagree from what I've seen so far. Nothing came close to the remote tests using Linuxthreads. > > Everyone here wants to say "But you're comparing apples to oranges!" > > and now you're telling me to do just that. > >No we're not. I want to know what aspects of those >mysql conf settings affect FreeBSD performance. Perhaps >it can help find one of the bottlenecks. I'm just getting frustrated here having to go from list to list and repeat everything that has already been posted each time as each group wants to push the problem on another group... starting to remind me of the Healthcare system, but none of us can fix that problem :P > > Why don't we compare apples to apples and use stock my.cnf settings > > for both? > >That's fine. You were trying to run dual tests (stock and huge >my.cnf settings) on each platform but mostly chose to look at >huge cnf remote results. I only stressed the my-huge.cnf results because they (on i386, using Linuxthreads, remote) was the only thing that came anywhere near the Linux results. I'll try to put a page up that consolidates the results so far.