From owner-freebsd-current@FreeBSD.ORG  Wed Oct 26 12:38:09 2005
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
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 9922C16A41F
	for <current@freebsd.org>; Wed, 26 Oct 2005 12:38:09 +0000 (GMT)
	(envelope-from rwatson@FreeBSD.org)
Received: from cyrus.watson.org (cyrus.watson.org [209.31.154.42])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3545D43D7B
	for <current@freebsd.org>; Wed, 26 Oct 2005 12:38:09 +0000 (GMT)
	(envelope-from rwatson@FreeBSD.org)
Received: from fledge.watson.org (fledge.watson.org [209.31.154.41])
	by cyrus.watson.org (Postfix) with ESMTP id 9F58546B4C;
	Wed, 26 Oct 2005 08:38:07 -0400 (EDT)
Date: Wed, 26 Oct 2005 13:38:07 +0100 (BST)
From: Robert Watson <rwatson@FreeBSD.org>
X-X-Sender: robert@fledge.watson.org
To: Marian Hettwer <MH@kernel32.de>
In-Reply-To: <435F6B01.5020003@kernel32.de>
Message-ID: <20051026133606.O32255@fledge.watson.org>
References: <435F48DA.6060009@kernel32.de>
	<20051026105411.L32255@fledge.watson.org>
	<435F6B01.5020003@kernel32.de>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
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
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>, 
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 26 Oct 2005 12:38:09 -0000


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.

> 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. :-)

BTW, you're running MySQL over UNIX domain sockets, not TCP, right?

Robert N M Watson