From owner-freebsd-database Wed Jan 10 10:20:15 2001 Delivered-To: freebsd-database@freebsd.org Received: from server.bitmcnit.bryansk.su (bitmcnit.bryansk.ru [195.239.213.9]) by hub.freebsd.org (Postfix) with ESMTP id EF93F37B6A2 for ; Wed, 10 Jan 2001 10:18:35 -0800 (PST) Received: (from uucp@localhost) by server.bitmcnit.bryansk.su (8.9.3/8.9.3) with UUCP id VAA25074; Wed, 10 Jan 2001 21:05:23 +0300 Received: (from alex@localhost) by kapran.bitmcnit.bryansk.su (8.11.1/8.11.1) id f0AHsmD01357; Wed, 10 Jan 2001 20:54:48 +0300 (MSK) (envelope-from alex@kapran.bitmcnit.bryansk.su) Date: Wed, 10 Jan 2001 20:54:47 +0300 From: Alex Kapranoff To: Tom Samplonius Cc: Lauri Laupmaa , database@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110205447.A824@kapran.bitmcnit.bryansk.su> References: <3A5C742A.620F9B00@inspiral.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from tom@sdf.com on Wed, Jan 10, 2001 at 08:24:04AM -0800 X-Operating-System: FreeBSD 5.0-CURRENT i386 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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. -- Alex Kapranoff, Voice: +7(0832)791845 We've lived 236 hours in the brand new millenium... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message