Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 26 Oct 2005 14:49:43 +0200
From:      Marian Hettwer <MH@kernel32.de>
To:        Robert Watson <rwatson@FreeBSD.org>
Cc:        current@freebsd.org
Subject:   Re: MySQL Performance 6.0rc1
Message-ID:  <435F7B67.5080709@kernel32.de>
In-Reply-To: <20051026133606.O32255@fledge.watson.org>
References:  <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> <435F6B01.5020003@kernel32.de> <20051026133606.O32255@fledge.watson.org>

next in thread | previous in thread | raw e-mail | index | archive | help
Hi Robert,

Robert Watson wrote:
> 
> On Wed, 26 Oct 2005, Marian Hettwer wrote:
> 
>>> - Use libmap to configure the mysql server to use libthr instead of
>>>   libpthread
>>>
>> uh. Last time I fiddled around with libmap.conf was back in FreeBSD 
>> 5.1 ... could you enlighten me a wee bit in regards to libmap.conf ? 
>> :) If not, I'll stress google a bit and hopefully find something 
>> useful...
> 
> 
> libmap.conf(5) has the details, including examples.  The easy (cheating) 
> way to accomplish the same thing is to replace /usr/lib/libpthread with 
> /usr/lib/libthr :-).  Remember that for linker changes to the thread 
> library to affect an application, you need to stop and restart the 
> application.
>
Thanks for the input. I give it a try and report back later :-)

>> my.cnf is pretty much my-medium.cnf on Debian and FreeBSD. Although, 
>> Debian has MySQL 4.1.11 and FreeBSD Ports has MySQL 4.1.14. As 
>> mentioned before, this benchmark here is a quick shot. However, the 
>> difference shouldn't be _that_ large (3600 vs. 14000).
> 
> 
> I think you will find people generally agree with this viewpoint. :-)
> 
Ack. the difference is that huge... well, for some reasons I don't know, 
I think a look into Linux' way of threading may be worth, hm?

> BTW, you're running MySQL over UNIX domain sockets, not TCP, right?
>
indeed. Connect via /tmp/mysql.sock no network involved...

best regards,
Marian



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