From owner-freebsd-performance@FreeBSD.ORG  Wed Nov 28 19:51:51 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 0806F16A476
	for <Freebsd-performance@freebsd.org>;
	Wed, 28 Nov 2007 19:51:51 +0000 (UTC)
	(envelope-from bright@elvis.mu.org)
Received: from elvis.mu.org (elvis.mu.org [192.203.228.196])
	by mx1.freebsd.org (Postfix) with ESMTP id F2DEE13C447
	for <Freebsd-performance@freebsd.org>;
	Wed, 28 Nov 2007 19:51:50 +0000 (UTC)
	(envelope-from bright@elvis.mu.org)
Received: by elvis.mu.org (Postfix, from userid 1192)
	id 32A081A4D81; Wed, 28 Nov 2007 11:31:58 -0800 (PST)
Date: Wed, 28 Nov 2007 11:31:58 -0800
From: Alfred Perlstein <alfred@freebsd.org>
To: Kris Kennaway <kris@FreeBSD.org>
Message-ID: <20071128193158.GD71382@elvis.mu.org>
References: <03db01c831cc$8ead9890$b6db87d4@multiplay.co.uk>
	<474DBDE8.10107@FreeBSD.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <474DBDE8.10107@FreeBSD.org>
User-Agent: Mutt/1.4.2.3i
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:51:51 -0000

* 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.

-- 
- Alfred Perlstein