From owner-freebsd-threads@FreeBSD.ORG Sun May 23 21:03:09 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 A410916A4CE; Sun, 23 May 2004 21:03:09 -0700 (PDT) Received: from mail.mikehost.net (lvs-1.voxel.net [207.99.115.72]) by mx1.FreeBSD.org (Postfix) with ESMTP id 605C543D2F; Sun, 23 May 2004 21:03:09 -0700 (PDT) (envelope-from mike@mike2k.com) Received: by mail.mikehost.net (Postfix, from userid 502) id 8A0D71BC82; Sun, 23 May 2004 21:02:03 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by mail.mikehost.net (Postfix) with ESMTP id 888581BC7F; Sun, 23 May 2004 21:02:03 -0700 (PDT) Date: Sun, 23 May 2004 21:02:03 -0700 (PDT) From: mike X-X-Sender: mike@sql01.internal.mikehost.net To: David Xu In-Reply-To: <40B13BB3.3030807@freebsd.org> Message-ID: References: <5.2.0.9.2.20040523104834.01465598@mail.ojoink.com> <5.2.0.9.2.20040523102747.015557e8@mail.ojoink.com> <5.2.0.9.2.20040523090659.01628af8@mail.ojoink.com> <5.2.0.9.2.20040522135338.0158cc50@mail.ojoink.com> <5.2.0.9.2.20040522100318.01598f50@mail.ojoink.com> <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.20040522052606.0156fd70@mail.ojoink.com> <5.2.0.9.2.20040522100318.01598f50@mail.ojoink.com> <5.2.0.9.2.20040522135338.0158cc50@mail.ojoink.com> <5.2.0.9.2.20040523090659.01628af8@mail.ojoink.com> <5.2.0.9.2.20040523102747.015557e8@mail.ojoink.com> <5.2.0.9.2.20040523104834.01465598@mail.ojoink.com> <40B13BB3.3030807@freebsd.org> mike: yes MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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: Mon, 24 May 2004 04:03:09 -0000 > > > > > Note that default mysql table type is mysql, which uses Giant Lock when > doing update on table, it does not support concurrent update, each thread > wants to update the table will be serialized, fix me if I am wrong, but some > years ago, mysql book tells me the fact, you might need to look other types, > for example, BDB or innodb. 50% cpu usage on SMP machine is normal for > MySQL server using mysql table type. > > David Xu i just want to note - either way, running the same benchmarking utilities on linux shows linux outperforming freebsd hands down. this isn't a theoretical debate on why mysql performance might be slow. it works fine on linux - our question is why we can't get that type of performance out of freebsd. to reiterate for the nth time - i'm pledging $250 to whomever will own this/fix it. i believe two other parties will pledge another combined $250 as well. that's $500 to do something that [overall] benefits freebsd users, especially those wishing to run high performance mysql servers on freebsd. we want it to at least match linux performance, if not be able to exceed it. right now we're just going in loops with requests for more benchmarks and such. if it's worth $500, someone "in the know" step up and we'll give you access to one of our boxes, you can do whatever you want to get it to perform how we'd like. at least 2 or 3 of us have pretty similarly configured machines, so if you can get it to work good on one, that should be able to be applied to all, if it's not a permanent obvious fix in the freebsd kernel, scheduler, threading, or just a patch to get more out of mysql on freebsd 5.x. - mike