From owner-freebsd-database Wed Jan 10 11:15: 2 2001 Delivered-To: freebsd-database@freebsd.org Received: from mx.nsu.ru (mx.nsu.ru [193.124.215.71]) by hub.freebsd.org (Postfix) with ESMTP id EAD6837B400 for ; Wed, 10 Jan 2001 11:14:42 -0800 (PST) Received: from iclub.nsu.ru (root@iclub.nsu.ru [193.124.222.66]) by mx.nsu.ru (8.9.1/8.9.0) with ESMTP id BAA00917; Thu, 11 Jan 2001 01:13:20 +0600 (NOVT) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id f0AJDID13461; Thu, 11 Jan 2001 01:13:19 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Thu, 11 Jan 2001 01:13:18 +0600 (NS) From: Max Khon To: David Miller Cc: Alex Kapranoff , Tom Samplonius , 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 hi, there! On Wed, 10 Jan 2001, David Miller 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. FreeBSD threads do not spread over CPUs -current will have better SMP and better threads implementation (but AFAIK it is not here yet) /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message