From owner-freebsd-stable  Sun Dec 10  0:20: 6 2000
From owner-freebsd-stable@FreeBSD.ORG  Sun Dec 10 00:20:03 2000
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@freebsd.org
Received: from dns.comrax.com (dns.comrax.com [194.90.246.124])
	by hub.freebsd.org (Postfix) with ESMTP id 6D57037B400
	for <stable@freebsd.org>; Sun, 10 Dec 2000 00:20:00 -0800 (PST)
Received: from NOOR (unknown [156.27.243.27])
	by dns.comrax.com (Postfix) with SMTP
	id BD82612C6F1; Sun, 10 Dec 2000 10:17:52 +0200 (IST)
From: "Noor Dawod" <noor@comrax.com>
To: "Tom" <tom@uniserve.com>, "Rick Jansen" <Rick@Tweakers.net>
Cc: <stable@freebsd.org>
Subject: RE: MySQLd not using both CPUs
Date: Sun, 10 Dec 2000 10:19:58 +0200
Message-ID: <PHEBIOJOBJJLIIJCOINKIEDFCPAA.noor@comrax.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
In-Reply-To: <Pine.BSF.4.05.10012092119440.20875-100000@shell.uniserve.ca>
Sender: owner-freebsd-stable@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Hi,

If you start multiple mysqld's, will each one process occupy same memory
as its friend? Or is it that first process uses a certain amount of
memory, and then each instance uses a portion of the system memory and
shares the other with the main process?

Noor

-----Original Message-----
From: owner-freebsd-stable@FreeBSD.ORG
[mailto:owner-freebsd-stable@FreeBSD.ORG]On Behalf Of Tom
Sent: Sunday, December 10, 2000 7:22 AM
To: Rick Jansen
Cc: stable@freebsd.org
Subject: Re: MySQLd not using both CPUs


On Sun, 10 Dec 2000, Rick Jansen wrote:
...
> it says the machine is around 49% idle! This leads me to conclude that
MySQL
> is jusing just one processor. What can i do about this? It's an awful
waste
> of such a nice P3 733..
...

  With the current FreeBSD architecture, since there is only one
process,
it can only run one CPU at a time.

  You can run multiple mysqld's to circumvent this.  This is warmly
recommended for other reasons.  There is a new startup script included
with the newer version of MySQL designed to start lots of mysqlds
(mainly
for vhosting).

Tom
Uniserve



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



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