Status of MySQL on 7 w/o patches applied

[Peter Schuller]

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).

-- 
/ Peter Schuller

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-current/attachments/20071016/bdd01a62/attachment.pgp