RE: mySQL 5 and CPu at 99.99%

Thank you very much, I will have a look at it. -Original Message- From: leo huang [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 3:47 AM To: Taiyo Cc: mysql@lists.mysql.com Subject: Re: mySQL 5 and CPu at 99.99% hi, Taiyo >| innodb_buffer_pool_size | 8388

RE: Connecting to queries into one

select consumers.id from consumers LEFT JOIN cases ON consumers.id = cases.id WHERE consumers.date_of_birth = '?' AND cases.last_name = '?' AND cases.full_first_name = '?' -Original Message- From: Courtney Braafhart [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 1:31 PM To: mys

mySQL 5 and CPu at 99.99%

Greetings, We are running a server and the CPU is at %99.99 at all times, after about 2-3 hours of processing queries just hang, sounds like our hardware is weak but we are running a 4GB RAM Dual Xeons 3.4 at 64bit OS. I was hoping someone could look at our settings and would help us analyze this