From owner-freebsd-threads@FreeBSD.ORG Sun May 23 17:35:59 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 501A616A4CE for ; Sun, 23 May 2004 17:35:59 -0700 (PDT) Received: from mta09-svc.ntlworld.com (mta09-svc.ntlworld.com [62.253.162.49]) by mx1.FreeBSD.org (Postfix) with ESMTP id C372C43D1D for ; Sun, 23 May 2004 17:35:58 -0700 (PDT) (envelope-from tom.hurst@clara.net) Received: from voi.aagh.net ([81.104.55.176]) by mta09-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040524003537.MDUU20971.mta09-svc.ntlworld.com@voi.aagh.net> for ; Mon, 24 May 2004 01:35:37 +0100 Received: from freaky by voi.aagh.net with local (Exim 4.34; FreeBSD) id 1BS3Qn-0000oH-VU for freebsd-threads@freebsd.org; Mon, 24 May 2004 01:35:05 +0100 Date: Mon, 24 May 2004 01:35:05 +0100 From: Thomas Hurst To: freebsd-threads@freebsd.org Message-ID: <20040524003505.GB2713@voi.aagh.net> Mail-Followup-To: freebsd-threads@freebsd.org References: <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.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> <5.2.0.9.2.20040523114544.014d8150@mail.ojoink.com> <40B13BB3.3030807@freebsd.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40B13BB3.3030807@freebsd.org> Organization: Not much. User-Agent: Mutt/1.5.6i Sender: Thomas Hurst 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 00:35:59 -0000 * David Xu (davidxu@freebsd.org) wrote: > 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. Only if you're only using one table. While this is true in this benchmark, it isn't really relevent because we're only testing selects, which are pure reads. There should be no table locking getting in the way; Linux's performance would seem to confirm this. -- Thomas 'Freaky' Hurst - freaky@aagh.net - http://www.aagh.net/