From owner-freebsd-threads@FreeBSD.ORG Sat May 22 13:52:28 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 A218916A4CE for ; Sat, 22 May 2004 13:52:28 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 95F2E43D49 for ; Sat, 22 May 2004 13:52:28 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 15592 invoked by uid 89); 22 May 2004 20:56:35 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 22 May 2004 20:56:35 -0000 Message-Id: <5.2.0.9.2.20040522135203.0165ea38@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 13:52:13 -0700 To: freebsd-threads@freebsd.org From: JG Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable 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 20:52:28 -0000 At 08:53 PM 5/22/2004 +0300, you wrote: >JG wrote: > >> >>The best FreeBSD config I've got on my AMD64 64-bit hardware was >>running 32-bit i386 FreeBSD with MySQL compiled with Linuxthreads. >>And those results were poor compared to Linux tests - they were >>just much higher than any other FreeBSD config. >Sure. I run mysql with linuxthreads because that was the only viable=20 >option a while ago. Based on the results of myself and others who have posted on this same= subject, It also appears the be the best "viable option" _now_ as well. >>I's been established on the other lists that threading is not being=20 >>handled properly to begin with. >>That has been the longtime crux with MySQL on FreeBSD, and why=20 >>"Linuxthreads" has been >>recommended for so long as well, no? >> >>Also, we see almost nearly the same results running on a single CPU as=20 >>we do when we run SMP >> >> - I don't believe the HD is to blame here. >People with religion don=B4t do well on science. You have to pick if you= are=20 >open to the truth or if you have made your mind up already. People with delusions of infallibility don't do well with listening to=20 other people's suggestions or discoveries. >If you read my message again and follow it=B4s logic, you=B4ll find it does= =20 >not "blame the HD" but if you are disk-bound it does not help if you have= =20 >one, two, four or a gazillion CPU's because they are not going to go any=20 >faster. > I don=B4t have an opinion of 32 vs 64 bit mode but with Opteron CPU's the= =20 > performance in both environments is very close, you should not expect 64= =20 > bit mode to run double the speed of 32 bit mode. Who said anything about expecting double the performance when using a 64=20 bit machine? I don't expect all V8 engines to outperform all 4 cylinder=20 engines by twice as much either, go figure.