Date: Wed, 28 Nov 2007 11:31:58 -0800 From: Alfred Perlstein <alfred@freebsd.org> To: Kris Kennaway <kris@FreeBSD.org> Cc: Freebsd-performance@freebsd.org, Steven Hartland <killing@multiplay.co.uk> Subject: Re: Poor mysql scaling across the board pre 5.1.22? Message-ID: <20071128193158.GD71382@elvis.mu.org> In-Reply-To: <474DBDE8.10107@FreeBSD.org> References: <03db01c831cc$8ead9890$b6db87d4@multiplay.co.uk> <474DBDE8.10107@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
* 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071128193158.GD71382>