mysql - linuxthreads

[Kris Kennaway]

On Fri, Jan 27, 2006 at 03:15:05PM -0500, Romeo Theriault wrote:
> A week or so ago I wrote to the this list asking about Freebsd and  
> Mysql, wondering if you still needed to compile Mysql with  
> linuxthreads to get better performance under Freebsd 6. I didn't get  
> much of a response so I looked around for the answer. I thought I'd  
> write back to the mailing list to tell anyone interested what I found.

Thanks, this is always useful!

> In the Freebsd 6.0 is seems that to get the best MySQL performance  
> you need to do a few things.
> 	#compile your kernel with the ULE scheduler

I'd be inclined to doubt this..all my measurements show ULE is slower
than 4BSD except at negligible load.  How did you measure it?

> 	#use the TSC timecounter
> 	#use the libthr threading library with mysql

You definitely want libthr.

Kris
-------------- 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-questions/attachments/20060127/d7713d62/attachment.bin