From owner-freebsd-database  Wed Jan 10  9: 9:58 2001
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 CC21437B401
	for <database@freebsd.org>; Wed, 10 Jan 2001 09:09:35 -0800 (PST)
Received: from tom (helo=localhost)
	by misery.sdf.com with local-esmtp (Exim 2.12 #1)
	id 14GO2q-0006X3-00; Wed, 10 Jan 2001 08:24:16 -0800
Date: Wed, 10 Jan 2001 08:24:04 -0800 (PST)
From: Tom Samplonius <tom@sdf.com>
To: Lauri Laupmaa <mauri@inspiral.net>
Cc: database@freebsd.org
Subject: Re: mysql (smp) performance
In-Reply-To: <3A5C742A.620F9B00@inspiral.net>
Message-ID: <Pine.BSF.4.05.10101100821490.21469-100000@misery.sdf.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; CHARSET=US-ASCII
Content-ID: <Pine.BSF.4.05.10101100821492.21469@misery.sdf.com>
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG


On Wed, 10 Jan 2001, Lauri Laupmaa wrote:

...
> It seems that on SMP mysql doesn't scale well. (currently testing on
> dual 833 PIII and running on couple older dual systems)

  Because there is no such thing as SMP mysql.  It is a single process,
and can only run on a single processor at a time.

> I'm interested if there is some magic to get mysql run faster ?
> Or should I use 5.x-CURRENT ?

  You can run multiple instances of mysql.  You may want to do this
anyways, if you are using mysql in a hosting environment.

> TIA
> 
> L.

Tom



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