mysql - linuxthreads

[Romeo Theriault]

I didn't personally measure it, though someday I hope to be able to,  
but I did read in several places that using the ULE scheduler was the  
better choice to use with FreeBSD. Here are the links that are  
noteworthy:

http://wikitest.freebsd.org/moin.cgi/MySQL
http://blog.gslin.org/archives/2005/12/12/252/

Romeo

On Jan 27, 2006, at 3:22 PM, Kris Kennaway wrote:

> 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