Skip site navigation (1)Skip section navigation (2)
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>