From owner-freebsd-amd64@FreeBSD.ORG Tue May 18 17:06:22 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7E0EC16A4CF for ; Tue, 18 May 2004 17:06:22 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4190343D46 for ; Tue, 18 May 2004 17:06:22 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 22637 invoked by uid 89); 19 May 2004 00:10:01 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 19 May 2004 00:10:01 -0000 Message-Id: <5.2.0.9.2.20040518170424.03c42748@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Tue, 18 May 2004 17:05:51 -0700 To: freebsd-amd64@freebsd.org From: JG In-Reply-To: <200405181359.18291.peter@wemm.org> References: <5.2.0.9.2.20040518103357.04c6cbb8@mail.ojoink.com> <5.2.0.9.2.20040518103357.04c6cbb8@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/AMD64 Vs. FreeBSD/AMD64? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 May 2004 00:06:23 -0000 At 01:59 PM 5/18/2004 -0700, you wrote: >On Tuesday 18 May 2004 10:36 am, JG wrote: > > > MySQL Statically compiled with libc_r > ^^^^^ >That's your killer. You're using the the single-process polling loop >based threads and comparing it to linux's parallel process based >threads. The moment one thread blocks on disk IO, everything stops. > >You want -lpthread instead, but this isn't going to be happy on >5.2.1-RELEASE. I've fixed a lot of bugs in 5-current that would mean >the difference between it working versus crashing. > >Also, there are patches to change MySQL to use PTHREAD_SCOPE_PROCESS >threads with -lpthread. This works out a little better on benchmarks >since it can make better use of the ligher weight context switches. > >-- >Peter Wemm - peter@wemm.org; peter@FreeBSD.org; peter@yahoo-inc.com >"All of this is for nothing if we don't go to the stars" - JMS/B5 Yes I'll definitely try this next. Thanks to everyone for all the tips & suggestions. I'll post some updated results tomorrow sometime.