From owner-freebsd-questions  Tue Jun 11  9:27:37 2002
Delivered-To: freebsd-questions@freebsd.org
Received: from bamse.ktv.se (bamse.ktv.se [195.17.241.138])
	by hub.freebsd.org (Postfix) with ESMTP id 1947B37B40B
	for <freebsd-questions@FreeBSD.ORG>; Tue, 11 Jun 2002 09:27:32 -0700 (PDT)
Received: from leo.ktv.se (gw.ktv.se [194.52.13.251])
	by bamse.ktv.se (8.12.3/8.12.3) with ESMTP id g5BGReWM011120;
	Tue, 11 Jun 2002 18:27:41 +0200 (CEST)
	(envelope-from leo@ktv.se)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Leo De Geer <leo@ktv.se>
Reply-To: leo@ktv.se
Organization: Kristianstad Teknikverkstad
To: Dan Nelson <dnelson@allantgroup.com>
Subject: Re: problem with mysql threads on freebsd
Date: Tue, 11 Jun 2002 18:27:17 +0200
X-Mailer: KMail [version 1.4]
Cc: mysql@lists.mysql.com, freebsd-questions@FreeBSD.ORG
References: <200206110836.55860.leo@ktv.se> <20020611143008.GB14164@dan.emsphone.com>
In-Reply-To: <20020611143008.GB14164@dan.emsphone.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200206111827.17783.leo@ktv.se>
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG

On Tuesday 11 June 2002 16.30, Dan Nelson wrote:
> In the last episode (Jun 11), Leo De Geer said:
> > im not abel to get mysql to use more then one thread on my freebsd
> > 4.5-stable any one having a klue that wrong?????
>
> Do not assume that the way Linux manages threads is the only one.
> Mysql on FreeBSD does create threads; they are just not visible via top
> (in fact Linux is the only OS that shows threads in top).  FreeBSD's
> threads system, however will not put those threads on multiple CPUs.
> You can work around this by building the mysql port with LinuxThreads:
>
> cd /usr/ports/databases/mysql323-server
> make WITH_LINUXTHREADS=3Dyes
>
> This is only useful if your system is dedicated to mysql, though.  If
> it is a combination webserver/database, the other CPU will be busy
> enough serving webpages, and FreeBSD's regular threads will do fine.
thanks that is the thing i have looking for.

regards leo
--=20
MVH C. Leo De Geer
www.dinsignal.com
www.ktv.se
www.teknikshoppen.nu

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message