From owner-freebsd-stable Sat Dec 9 21:22:39 2000 From owner-freebsd-stable@FreeBSD.ORG Sat Dec 9 21:22:37 2000 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mail2.uniserve.com (mail2.uniserve.com [204.244.156.10]) by hub.freebsd.org (Postfix) with ESMTP id ECBC837B400 for ; Sat, 9 Dec 2000 21:22:36 -0800 (PST) Received: from shell.uniserve.ca ([204.244.186.218]) by mail2.uniserve.com with esmtp (Exim 3.13 #1) id 144ywT-000Ht0-00; Sat, 09 Dec 2000 21:22:33 -0800 Date: Sat, 9 Dec 2000 21:22:27 -0800 (PST) From: Tom X-Sender: tom@shell.uniserve.ca To: Rick Jansen Cc: stable@freebsd.org Subject: Re: MySQLd not using both CPUs In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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