From owner-freebsd-database  Fri Sep 22 21: 7:58 2000
Delivered-To: freebsd-database@freebsd.org
Received: from misery.sdf.com (misery.sdf.com [204.244.213.49])
	by hub.freebsd.org (Postfix) with ESMTP id E8D0F37B422
	for <freebsd-database@freebsd.org>; Fri, 22 Sep 2000 21:07:54 -0700 (PDT)
Received: from tom (helo=localhost)
	by misery.sdf.com with local-esmtp (Exim 2.12 #1)
	id 13cgEp-0006bj-00; Fri, 22 Sep 2000 20:44:31 -0700
Date: Fri, 22 Sep 2000 20:43:20 -0700 (PDT)
From: Tom Samplonius <tom@sdf.com>
To: Martin Jakobsen <mcoolj@cyberjunkie.dk>
Cc: freebsd-database@freebsd.org
Subject: Re: your mail
In-Reply-To: <00cf01c01d9e$7909d660$7801a8c0@here>
Message-ID: <Pine.BSF.4.05.10009222041050.25285-100000@misery.sdf.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG


On Wed, 13 Sep 2000, Martin Jakobsen wrote:

> Hello.
> I am trying to compile MySQL with mit-threads under FreeBSD 4.1.
> I have compiled the kernel for SMP and it runs excellent.
...
> Any ideas why this happens everytime?
> I have compiled it without mit-threads and it runs fine,
> but because the servers only purpose are to be a database server,
> I'd really like if it used both CPU's.

  It won't help.  Neither mit-threads nor native threads will balance the
threads of a single app over multiple CPUs.

  Solution?  If you have multiple databases, run separate instances of
mySQL for each.  Or perhaps, one instance for each customer.  There are
additional advantages to this approach too.

Tom



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