From owner-freebsd-threads@FreeBSD.ORG Sat May 22 10:53:30 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 5B89C16A4CE for ; Sat, 22 May 2004 10:53:30 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id B241D43D1F for ; Sat, 22 May 2004 10:53:29 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i4MHrM3v022183; Sat, 22 May 2004 20:53:22 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <40AF938D.5040400@he.iki.fi> Date: Sat, 22 May 2004 20:53:17 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: JG References: <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040521154458.01627688@127.0.0.1> <5.2.0.9.2.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040522094946.01588470@mail.ojoink.com> In-Reply-To: <5.2.0.9.2.20040522094946.01588470@mail.ojoink.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit cc: freebsd-threads@freebsd.org 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 17:53:30 -0000 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 option a while ago. > > I's been established on the other lists that threading is not being > handled properly to begin with. > That has been the longtime crux with MySQL on FreeBSD, and why > "Linuxthreads" has been > recommended for so long as well, no? > > Also, we see almost nearly the same results running on a single CPU > as we do when we run SMP > > - I don't believe the HD is to blame here. > People with religion donīt do well on science. You have to pick if you are open to the truth or if you have made your mind up already. If you read my message again and follow itīs logic, youīll find it does not "blame the HD" but if you are disk-bound it does not help if you have one, two, four or a gazillion CPU's because they are not going to go any faster. Most linuxen sacrifice data integrity over performance by default. FreeBSD is the other way around. I donīt have an opinion of 32 vs 64 bit mode but with Opteron CPU's the performance in both environments is very close, you should not expect 64 bit mode to run double the speed of 32 bit mode. Pete