From owner-freebsd-database Wed Jan 10 20:58:35 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 2725337B400 for ; Wed, 10 Jan 2001 20:58:18 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 14GZ6G-0007Td-00; Wed, 10 Jan 2001 20:12:32 -0800 Date: Wed, 10 Jan 2001 20:12:30 -0800 (PST) From: Tom Samplonius To: Alex Kapranoff Cc: 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: > > 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. Well, multiprocessing will take advantage of SMP just as good as multithreading. However, today FreeBSD can't schedule threads belong to a single process on more than one CPU. > -- > Alex Kapranoff, Voice: +7(0832)791845 > We've lived 236 hours in the brand new millenium... Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message