From owner-freebsd-performance@FreeBSD.ORG Wed Nov 28 19:13:35 2007 Return-Path: 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 83FD416A421 for ; Wed, 28 Nov 2007 19:13:35 +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 D8ACF13C4CE; Wed, 28 Nov 2007 19:13:34 +0000 (UTC) (envelope-from kris@FreeBSD.org) Message-ID: <474DBDE8.10107@FreeBSD.org> Date: Wed, 28 Nov 2007 20:13:44 +0100 From: Kris Kennaway User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031) MIME-Version: 1.0 To: Steven Hartland References: <03db01c831cc$8ead9890$b6db87d4@multiplay.co.uk> In-Reply-To: <03db01c831cc$8ead9890$b6db87d4@multiplay.co.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Freebsd-performance@freebsd.org 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Nov 2007 19:13:35 -0000 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. Kris