From owner-freebsd-stable Wed Dec 12 14: 0:18 2001 Delivered-To: freebsd-stable@freebsd.org Received: from hercules.icarz.com (ns1.icarz.com [207.99.22.7]) by hub.freebsd.org (Postfix) with ESMTP id 541DD37B416 for ; Wed, 12 Dec 2001 14:00:08 -0800 (PST) Received: from newken (dhcp113.icarz.com [207.99.22.113]) by hercules.icarz.com (8.10.1/8.10.1) with SMTP id fBCK3Bf29714; Wed, 12 Dec 2001 15:03:11 -0500 (EST) Message-ID: <021c01c18347$ac0af340$711663cf@icarz.com> From: "Ken Menzel" To: "Chynnee" , "Andrew Tulloch" Cc: References: <077a01c18332$3ffd4190$4c0116ac@ANDREWT> <025c01c18336$649e1980$0701a8c0@desktop> Subject: Re: SMP and MySQL/threads Date: Wed, 12 Dec 2001 15:00:39 -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 Hi Brad and Andrew, Maybe pthread CAN run on different CPU's, but I know that MySQL runs on only one CPU with native BSD threads and mutliple CPU's with Linux threads. I have tested this and currently have problems with running out of CPU occasionally on 1 processor and response times dropping off (single process goes to 99% in top, overall cpu usage stays below 50%, dual CPU machine, responses to other users slow or stopped (different databases in use), could be a bug in MySQL or threads having to do with waiting threads). (BTW to answer the original posters question, I also have been running Linux threads for several months with no problems). I want to run Linux threads on production machines but I am skittish about running anything where I don't fully understand how the module is built. I can get the port to build just fine, but I can't seem to build a working Linux Threaded MySQL outside of the port environment (I like to build from the tar file!). I am not sure this is a topic for -stable, maybe this would be more appropiate for ports. Unless there is a way to make MySQL use native threads better. I understood that having a single process use more than one CPU in FreeBSD threads was a feature coming in 5.0? Is this wrong? See: http://www.bsdtoday.com/2001/June/News508.html If something in MySQL needs to change I am sure they will change it to make it work better. We as the BSD community have to tell them what needs to be done. MySQL is critcal to our business, and it's important to us that it works as well as possible. I am sure other FreeBSD users are in this position as well. Besides, I don't like penguins. Ken ----- Original Message ----- From: "Chynnee" To: "Andrew Tulloch" Cc: Sent: Wednesday, December 12, 2001 12:56 PM Subject: Re: SMP and MySQL/threads > 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 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message