From owner-freebsd-stable Wed Dec 12 16:51:14 2001 Delivered-To: freebsd-stable@freebsd.org Received: from mail.viasoft.com.cn (unknown [61.153.1.177]) by hub.freebsd.org (Postfix) with ESMTP id 2E58E37B419 for ; Wed, 12 Dec 2001 16:51:11 -0800 (PST) Received: from viasoft.com.cn (davidwnt.viasoft.com.cn [192.168.1.239]) by mail.viasoft.com.cn (8.9.3/8.9.3) with ESMTP id IAA03313; Thu, 13 Dec 2001 08:58:42 +0800 Message-ID: <3C17FA33.3070906@viasoft.com.cn> Date: Thu, 13 Dec 2001 08:45:39 +0800 From: David Xu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2 X-Accept-Language: en-us MIME-Version: 1.0 To: Andrew Tulloch Cc: freebsd-stable@FreeBSD.ORG Subject: Re: SMP and MySQL/threads References: <077a01c18332$3ffd4190$4c0116ac@ANDREWT> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG If you need performance, keep it with Linux until FreeBSD 5.0 is ready. current pthread implement in FreeBSD 4 is user level thread, and all disk access will be serialized and whole threads can only run in one processor. -- David Xu Andrew Tulloch wrote: >I currently have two SMP PIII-800 machines with 1gig of ram running Redhat >that I've inherited the administration of, their main task is currently to >run MySQL. I've been wanting to move them over to FreeBSD to reduce >administrative overhead, however my current understanding is that threads >are implemented using the pthread library inside a single process that means >two threads cannot run on seperate CPUs at the same time, which is obviously >something I'd want on a machine most running MySQL. I'm farily certain I'd >have quite a lot of wasted CPU time with MySQL running on just one >processor. I've looked at the makefile of the port and that has the option >to compile the port with linuxthreads, however it warns it should not be >used for production and that I should expect problems. Has anyone tried this >or has any other recommendations? > >Cheers >Andrew > > >To Unsubscribe: send mail to majordomo@FreeBSD.org >with "unsubscribe freebsd-stable" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message