Date: Wed, 12 Dec 2001 12:56:58 -0500 From: "Chynnee" <chynnee@mindspring.com> To: "Andrew Tulloch" <andrewt@great4.co.uk> Cc: <stable@freebsd.org> Subject: Re: SMP and MySQL/threads Message-ID: <025c01c18336$649e1980$0701a8c0@desktop> References: <077a01c18332$3ffd4190$4c0116ac@ANDREWT>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <andrewt@great4.co.uk> To: <freebsd-stable@freebsd.org> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?025c01c18336$649e1980$0701a8c0>