From owner-freebsd-database Wed Jan 10 10:55:38 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 970BB37B400 for ; Wed, 10 Jan 2001 10:55:21 -0800 (PST) Received: by search.sparks.net (Postfix, from userid 100) id 56FACDB25; Wed, 10 Jan 2001 13:54:28 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id 39142DB21; Wed, 10 Jan 2001 13:54:28 -0500 (EST) Date: Wed, 10 Jan 2001 13:54:28 -0500 (EST) From: David Miller To: Alex Kapranoff Cc: Tom Samplonius , Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance In-Reply-To: <20010110205447.A824@kapran.bitmcnit.bryansk.su> 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, Alex Kapranoff wrote: > On Wed, Jan 10, 2001 at 08:24:04AM -0800, 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. > > MySQL is heavily multithreaded and thus should take advantage of good SMP. Only if it likes the threads of the host, and if the host manages those threads efficiently. I've "heard all around" that this is a poor area for FreeBSD, but would love to hear from someone who can speak with firsthand knowledge about freebsd threads and mysql. Thanks, --- David To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message