From owner-freebsd-stable Wed Dec 12 9:27:25 2001 Delivered-To: freebsd-stable@freebsd.org Received: from biliskner.great4.co.uk (biliskner.great4.co.uk [213.86.13.125]) by hub.freebsd.org (Postfix) with ESMTP id 4C38C37B405 for ; Wed, 12 Dec 2001 09:27:20 -0800 (PST) Received: from ANDREWT (andrewt.topaz [172.22.1.76]) by biliskner.great4.co.uk (Postfix) with ESMTP id 6FE5C5409 for ; Wed, 12 Dec 2001 17:28:13 +0000 (GMT) Message-ID: <077a01c18332$3ffd4190$4c0116ac@ANDREWT> From: "Andrew Tulloch" To: Subject: SMP and MySQL/threads Date: Wed, 12 Dec 2001 17:27:18 -0000 Organization: Great4 Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 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 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