From owner-freebsd-stable Wed Dec 12 9:57:11 2001 Delivered-To: freebsd-stable@freebsd.org Received: from tisch.mail.mindspring.net (tisch.mail.mindspring.net [207.69.200.157]) by hub.freebsd.org (Postfix) with ESMTP id 711FC37B41B for ; Wed, 12 Dec 2001 09:57:04 -0800 (PST) Received: from user-112urr6.biz.mindspring.com ([66.47.111.102] helo=desktop) by tisch.mail.mindspring.net with smtp (Exim 3.33 #1) id 16EDcm-0001Gq-00; Wed, 12 Dec 2001 12:56:56 -0500 Message-ID: <025c01c18336$649e1980$0701a8c0@desktop> From: "Chynnee" To: "Andrew Tulloch" Cc: References: <077a01c18332$3ffd4190$4c0116ac@ANDREWT> Subject: Re: SMP and MySQL/threads Date: Wed, 12 Dec 2001 12:56:58 -0500 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 Pthread's threads CAN run on different CPUs if they are giving the right attributes: pthread_attr_setscope(&thread_attributes, PTHREAD_SCOPE_SYSTEM); then the "thread_attribute" is used when creating the thread. mysql seems to use this attribute. maybe if someone is running it on a SMP box, they could tell us more. (i am all about these thread questions today, but if i am wrong someone please correct me) brad ----- Original Message ----- From: "Andrew Tulloch" To: Sent: Wednesday, December 12, 2001 12:27 PM Subject: SMP and MySQL/threads > 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