Date: Fri, 17 Jun 2005 19:36:20 +0100 From: Thomas Hurst <tom.hurst@clara.net> To: David Sze <dsze@alumni.uwaterloo.ca> Cc: freebsd-stable@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <20050617183620.GB8376@voi.aagh.net> In-Reply-To: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net> References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net>
next in thread | previous in thread | raw e-mail | index | archive | help
* David Sze (dsze@alumni.uwaterloo.ca) wrote: > super-smack select-key > 5.4-RELEASE ~20,000 queries/second > 6.0-CURRENT ~24,000 queries/second > CentOS w/async ~36,000 queries/second > CentOS w/sync ~26,000 queries/second Uh, this should be an entirely cached set of reads, why does mounting sync reduce performance this much? Does FreeBSD see a similar boost with async mounts? > super-smack update-select > 5.4-RELEASE ~4,000 queries/second > 6.0-CURRENT ~4,500 queries/second > CentOS w/async ~7,500 queries/second > CentOS w/sync ~750 queries/second Is this even relevent? Async is by far the most common setup on Linux, one which seems very stable and safe, especially on XFS/Reiser. Of course if FreeBSD can't match Linux/async performance, but still perform like this on a potentially safer sync mount, that's fine by me, but I'm having trouble buying that select-key performance. Even standalone multi-second and non-concurrent selects demonstrate this 30-40% lower performance than Linux on the same hardware. -- Thomas 'Freaky' Hurst http://hur.st/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050617183620.GB8376>