Date: Wed, 28 Nov 2007 20:34:45 +0100 From: Kris Kennaway <kris@FreeBSD.org> To: Alfred Perlstein <alfred@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: <474DC2D5.60107@FreeBSD.org> In-Reply-To: <20071128193158.GD71382@elvis.mu.org> References: <03db01c831cc$8ead9890$b6db87d4@multiplay.co.uk> <474DBDE8.10107@FreeBSD.org> <20071128193158.GD71382@elvis.mu.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?474DC2D5.60107>