Status of MySQL on 7 w/o patches applied

[Kris Kennaway]

Thomas Hurst wrote:
> * Peter Schuller (peter.schuller at 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