Date: Tue, 16 Oct 2007 21:03:05 +0200 From: Kris Kennaway <kris@FreeBSD.org> To: Peter Schuller <peter.schuller@infidyne.com>, freebsd-current@freebsd.org Subject: Re: Status of MySQL on 7 w/o patches applied Message-ID: <47150AE9.9070400@FreeBSD.org> In-Reply-To: <20071016171721.GB6566@voi.aagh.net> References: <20071016110642.GB54457@hyperion.scode.org> <20071016171721.GB6566@voi.aagh.net>
next in thread | previous in thread | raw e-mail | index | archive | help
Thomas Hurst wrote: > * Peter Schuller (peter.schuller@infidyne.com) wrote: > >> My question is - what is the expected status of MySQL performance in >> FreeBSD 7 (without external patches) at this time? > > Most if not all of the relevent patches were applied months ago. We ran > MySQL in production for some time using both patched and later unpatched > 7-CURRENT with ULE for a while, and normal performance was easily > comparible with Linux and Solaris. > > We did see poor behavior with MySQL 5.1 and replication; the slave > thread needed periodic restarts because it would use progressively more > CPU and eventually fall behind, spending a long time in 'init' on every > query, which we didn't see in other OS's. Whether this was FreeBSD's or > MySQL's fault I don't know, but one certainly didn't like the other. When I tried mysql 5.1 on my usual benchmarks a few months ago, performance was terrible compared to 5.0. I wondered if they had made some ill-conceived architectural changes that increased contention even more than within 5.0. I didn't investigate it though. Kris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?47150AE9.9070400>