From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 12:49:58 2005 Return-Path: X-Original-To: current@freebsd.org Delivered-To: freebsd-current@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 52AE416A41F; Wed, 26 Oct 2005 12:49:58 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from crivens.unixoid.de (crivens.unixoid.de [81.169.171.191]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2D2B843D48; Wed, 26 Oct 2005 12:49:56 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from localhost (localhost [127.0.0.1]) by crivens.unixoid.de (Postfix) with ESMTP id 77E3B3FE0; Wed, 26 Oct 2005 14:49:55 +0200 (CEST) Received: from crivens.unixoid.de ([127.0.0.1]) by localhost (crivens.unixoid.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 35257-13; Wed, 26 Oct 2005 14:49:43 +0200 (CEST) Received: from [192.168.100.10] (p54BDD77B.dip.t-dialin.net [84.189.215.123]) by crivens.unixoid.de (Postfix) with ESMTP id 70E263F26; Wed, 26 Oct 2005 14:49:43 +0200 (CEST) Message-ID: <435F7B67.5080709@kernel32.de> Date: Wed, 26 Oct 2005 14:49:43 +0200 From: Marian Hettwer User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robert Watson References: <435F48DA.6060009@kernel32.de> <20051026105411.L32255@fledge.watson.org> <435F6B01.5020003@kernel32.de> <20051026133606.O32255@fledge.watson.org> In-Reply-To: <20051026133606.O32255@fledge.watson.org> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at unixoid.de Cc: current@freebsd.org Subject: Re: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Oct 2005 12:49:58 -0000 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