From owner-freebsd-database Wed Jan 10 9:39:49 2001 Delivered-To: freebsd-database@freebsd.org Received: from search.sparks.net (search.sparks.net [208.5.188.60]) by hub.freebsd.org (Postfix) with ESMTP id 517BF37B401 for ; Wed, 10 Jan 2001 09:39:32 -0800 (PST) Received: by search.sparks.net (Postfix, from userid 100) id EE32FDB23; Wed, 10 Jan 2001 12:38:39 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id DD9B2DB22; Wed, 10 Jan 2001 12:38:39 -0500 (EST) Date: Wed, 10 Jan 2001 12:38:39 -0500 (EST) From: David Miller To: Tom Samplonius Cc: Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: Message-ID: 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, 10 Jan 2001, Tom Samplonius wrote: > > 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. My understanding is that it's single process but multithreaded. When I asked a very similar question on a mysql list a year ago I was told that on linux it ran much better on multiple cpu's. --- David To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message