From owner-freebsd-questions@FreeBSD.ORG Fri May 11 09:12:22 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id BFAA616A402 for ; Fri, 11 May 2007 09:12:22 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.246]) by mx1.freebsd.org (Postfix) with ESMTP id 3FB4F13C459 for ; Fri, 11 May 2007 09:12:20 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: by an-out-0708.google.com with SMTP id d23so210949and for ; Fri, 11 May 2007 02:12:19 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=DzAmWSdwbfeGKRTjUPZwkJ/Iz0qaM95/CIui9aBs7t45mo0Bqz18yK6+SutCcar8A5l6ZnV2QdhZB7Y1u2irL7fNfVVp/fvNtmgoE9jkHzR+u/cF/k//eUbiF6kpd5x3mkjDKoIISh4YxaP0yJKvttBKxxOT59P/95+QTZXtfa8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jtzPuQjeAiqoIfyrTd96+jLOBdJ+UCZdOS2LBfMdV+thO0cxHByZHQIhT6lNyCvo2821ce4Zof0zdrxVrkn7P1e6hVd06COjdEtvEnhfC05JfdyAtSQFsmBNRui/3THGbi+e4ds15sB1ukptusRdYOdeNS9B2CwZfk5snxdH7nQ= Received: by 10.100.94.3 with SMTP id r3mr2031200anb.1178874739574; Fri, 11 May 2007 02:12:19 -0700 (PDT) Received: by 10.100.9.14 with HTTP; Fri, 11 May 2007 02:12:19 -0700 (PDT) Message-ID: <499c70c0705110212h400d2466wdf4d2fce6ef41884@mail.gmail.com> Date: Fri, 11 May 2007 12:12:19 +0300 From: "Abdullah Ibn Hamad Al-Marri" To: "Martin Blapp" In-Reply-To: <20070511105652.S2786@godot> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> <20070511105652.S2786@godot> Cc: FreeBSD Questions Subject: Re: MySQL slowness in SMP X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 May 2007 09:12:22 -0000 On 5/11/07, Martin Blapp wrote: > > Hi, > > It depends on the threading library you use. Can you please > show us the output of > > ldd /usr/local/libexec/mysqld ? > > You should use libthr instead of libpthread or libc_r in /etc/libmap.conf > for mysqld. > > -- > Martin > > Martin Blapp, > ------------------------------------------------------------------ > ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH > Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 > PGP: > PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E > ------------------------------------------------------------------ Here we go. ldd /usr/local/libexec/mysqld /usr/local/libexec/mysqld: libz.so.3 => /lib/libz.so.3 (0x28498000) libwrap.so.4 => /usr/lib/libwrap.so.4 (0x284a9000) libcrypt.so.3 => /lib/libcrypt.so.3 (0x284b0000) libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x284c9000) libm.so.4 => /lib/libm.so.4 (0x28598000) libpthread.so.2 => /usr/lib/libthr.so.2 (0x285ae000) libc.so.6 => /lib/libc.so.6 (0x285c1000) and here is the libmap.conf [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/