From owner-freebsd-questions@FreeBSD.ORG  Fri May 11 09:22:31 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 BAE0216A405
	for <freebsd-questions@freebsd.org>;
	Fri, 11 May 2007 09:22:31 +0000 (UTC) (envelope-from mb@imp.ch)
Received: from pop.imp.ch (mx2.imp.ch [157.161.9.17])
	by mx1.freebsd.org (Postfix) with ESMTP id 5B18D13C46C
	for <freebsd-questions@freebsd.org>;
	Fri, 11 May 2007 09:22:31 +0000 (UTC) (envelope-from mb@imp.ch)
Received: from godot (godot.imp.ch [157.161.4.8])
	by pop.imp.ch (8.13.8/8.13.8/Submit_imp) with ESMTP id l4B9MTiP098108; 
	Fri, 11 May 2007 11:22:30 +0200 (CEST) (envelope-from mb@imp.ch)
Date: Fri, 11 May 2007 11:22:29 +0200 (CEST)
From: Martin Blapp <mb@imp.ch>
X-X-Sender: mb@godot
To: Abdullah Ibn Hamad Al-Marri <almarrie@gmail.com>
In-Reply-To: <499c70c0705110212h400d2466wdf4d2fce6ef41884@mail.gmail.com>
Message-ID: <20070511112011.U2786@godot>
References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> 
	<20070511105652.S2786@godot>
	<499c70c0705110212h400d2466wdf4d2fce6ef41884@mail.gmail.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: MySQL slowness in SMP
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 11 May 2007 09:22:31 -0000


Hi,

Ohh, I overread that you already use libthr.

But ...

> 90293 mysql        19 100    0   434M   187M ucond  1 176.6H 95.95% mysqld

It looks like you did not turn on 'showing threads' in top, else you would
have seen that many mysqld's are running on cpu 0, other on cpu 1.

--
Martin

> /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/
>