From owner-freebsd-performance@FreeBSD.ORG  Wed Nov 28 19:34:36 2007
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: Freebsd-performance@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 570C016A4A9;
	Wed, 28 Nov 2007 19:34:36 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Received: from weak.local (pointyhat.freebsd.org [IPv6:2001:4f8:fff6::2b])
	by mx1.freebsd.org (Postfix) with ESMTP id 78B3413C4D1;
	Wed, 28 Nov 2007 19:34:35 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Message-ID: <474DC2D5.60107@FreeBSD.org>
Date: Wed, 28 Nov 2007 20:34:45 +0100
From: Kris Kennaway <kris@FreeBSD.org>
User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031)
MIME-Version: 1.0
To: Alfred Perlstein <alfred@freebsd.org>
References: <03db01c831cc$8ead9890$b6db87d4@multiplay.co.uk>
	<474DBDE8.10107@FreeBSD.org> <20071128193158.GD71382@elvis.mu.org>
In-Reply-To: <20071128193158.GD71382@elvis.mu.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Freebsd-performance@freebsd.org, Steven Hartland <killing@multiplay.co.uk>
Subject: Re: Poor mysql scaling across the board pre 5.1.22?
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 28 Nov 2007 19:34:36 -0000

Alfred Perlstein wrote:
> * Kris Kennaway <kris@FreeBSD.org> [071128 11:13] wrote:
>> Steven Hartland wrote:
>>> Some interesting comments here:
>>> http://www.anandtech.com/IT/showdoc.aspx?i=3162&p=10
>> Indeed, mysql 5.0 has poor scaling compared to postgresql (this affects 
>> reads but severely affects writes).  However when I tested the latest 
>> beta of 5.1 about 6 months ago I found it had about 50% lower 
>> performance than 5.0 in a read-only configuration.  Maybe they had left 
>> some debugging enabled or have since fixed it.
> 
> One thing that mysql can suffer from is the lack of row level locking
> for MYISAM tables, I found that to be a write performance killer with
> multiple concurrent accesses.
> 
> INNODB is supposedly better.

This was innodb, afaicr.

Kris