Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 16 Oct 2007 13:06:42 +0200
From:      Peter Schuller <peter.schuller@infidyne.com>
To:        freebsd-current@freebsd.org
Subject:   Status of MySQL on 7 w/o patches applied
Message-ID:  <20071016110642.GB54457@hyperion.scode.org>

next in thread | raw e-mail | index | archive | help

--rS8CxjVDS/+yyDmU
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hello,

a few months ago there were reports of huge MySQL performance
increases in FreeBSD 7, particularly in terms of scalability. In
benchmarks, FreeBSD 7 seemed to match or (for the scalability part)
exceed the performance of Linux.

The report on these indicates some uncommitted patches were used, one
of which was supposedly very important for performance (file
descriptor locking IIRC).

My question is - what is the expected status of MySQL performance in
FreeBSD 7 (without external patches) at this time?

I ask because I recently (a couple of weeks ago) did comparisons using
sysbench (comparable to what was used in the benchmark used previously
in the report) between 6.2 and 7-CURRENT. Selects were actually half
as fast or less than 6.2 in this particular case (identical hardware).

Now I realize I am not providing details here; I can most definitely
provide a lot more detail. But first, is this *expected*? Are there
patches that still have not been committed, or should we be expecting
that FreeBSD 7 as it appears in CVS is comparable to Linux or better
with MySQL?

I will endeavor to re-run these comparisons with RELENG_7 within the
near future (regardless of the answer to the above question).

--=20
/ Peter Schuller

PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey@scode.org
E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org


--rS8CxjVDS/+yyDmU
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHFJtCDNor2+l1i30RAgTbAJsEqZkIl4x+cgglV4sC8Dq30eJ97wCeNQ8u
CRxtl1vrLBwr0KqeriCcnII=
=Dcvd
-----END PGP SIGNATURE-----

--rS8CxjVDS/+yyDmU--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071016110642.GB54457>