From owner-freebsd-performance@FreeBSD.ORG  Sat Dec  1 15:41:43 2007
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id C311F16A469
	for <freebsd-performance@freebsd.org>;
	Sat,  1 Dec 2007 15:41:43 +0000 (UTC)
	(envelope-from 000.fbsd@quip.cz)
Received: from elsa.codelab.cz (elsa.codelab.cz [82.208.36.70])
	by mx1.freebsd.org (Postfix) with ESMTP id 2E36B13C455
	for <freebsd-performance@freebsd.org>;
	Sat,  1 Dec 2007 15:41:42 +0000 (UTC)
	(envelope-from 000.fbsd@quip.cz)
Received: from localhost (localhost.codelab.cz [127.0.0.1])
	by elsa.codelab.cz (Postfix) with ESMTP id DF51319E023;
	Sat,  1 Dec 2007 16:41:41 +0100 (CET)
Received: from [192.168.1.2] (r3a200.net.upc.cz [213.220.192.200])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by elsa.codelab.cz (Postfix) with ESMTP id 69B9E19E019;
	Sat,  1 Dec 2007 16:41:39 +0100 (CET)
Message-ID: <475180C6.2000502@quip.cz>
Date: Sat, 01 Dec 2007 16:41:58 +0100
From: Miroslav Lachman <000.fbsd@quip.cz>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.12) Gecko/20050915
X-Accept-Language: cz, cs, en, en-us
MIME-Version: 1.0
References: <20071129101729.GA57985@harmless.hu>
	<20071130143023.I884@192.168.1.107>
In-Reply-To: <20071130143023.I884@192.168.1.107>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Gergely CZUCZY <phoemix@harmless.hu>, freebsd-performance@freebsd.org
Subject: Re: mysql scaling questions
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 01 Dec 2007 15:41:43 -0000

Jeff Roberson wrote:
[...]
>> the MySQL binary is statically linked, i've built it
>> that way.
>>
>> ldd: /usr/local/libexec/mysqld: not a dynamic executable
>>
>> Though, maybe I should rebuild it dynamically to ensure it's
>> linked against libthr (and not pthread or c_r)...
>>
>> So, any tips, guesses, anything what can cause this?
>>

As Mike Tancsa suggested - rebuild MySQL dynamic and use these values in 
/etc/libmap.conf

# /etc/libmap.conf
#
# candidate          mapping
#
[/usr/local/libexec/mysqld]
libpthread.so.2      libthr.so.2
libpthread.so        libthr.so

Miroslav Lachman