with this CPU load, is there any database slowness or any other issues. regards anandkl
On 10/29/07, Devi <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm running only MySQL in that machine. That's why i can't understand why > it consumes only 50% of CPU. Interestingly its nice% is also 0. > > I mean only if MySQL utilizes the full CPU, i can estimate the performance > of MySQL for different Client Applications. > > > Thanks > DEVI.G > > ----- Original Message ----- > *From:* Ananda Kumar <[EMAIL PROTECTED]> > *To:* Devi <[EMAIL PROTECTED]> > *Cc:* mysql@lists.mysql.com > *Sent:* Monday, October 29, 2007 2:33 PM > *Subject:* Re: Under utilization of CPU by MySQL > > > This says, that all app running on this machine are using 50% CPU (50%us). > > "If not wrong, for any application, we can estimate the performance level > only it its idle time is less than 5%." > > What do u mean by the above statement. > > regards > anandkl > > > > > On 10/29/07, Devi <[EMAIL PROTECTED]> wrote: > > > > Hi Anand, > > > > Thanks for the immediate response. > > > > The us% is around 50 and sy% is around 10. Other than idle some 3-5% > > was > > given to software & hardware interrupts. > > > > If not wrong, for any application, we can estimate the performance level > > only it its idle time is less than 5%. > > > > > > Thanks > > DEVI.G > > ----- Original Message ----- > > From: "Ananda Kumar" <[EMAIL PROTECTED]> > > To: "Devi" <[EMAIL PROTECTED]> > > Cc: < mysql@lists.mysql.com> > > Sent: Monday, October 29, 2007 1:10 PM > > Subject: Re: Under utilization of CPU by MySQL > > > > > > > Hi Devi, > > > If idle time is around 37%, it means your cpu is 63% utilized. It > > again > > > depends on what kind of query is running on ur system. > > > > > > Can u also please check %us, %wa and %sy. > > > %us will give amount cpu utilized by any applicaiton running on the > > > machine. > > > > > > %wa will give amount of wait io. > > > > > > %sys will give cpu utilized by system kernal. > > > > > > regards > > > anandkl > > > > > > > > > On 10/29/07, Devi < [EMAIL PROTECTED]> wrote: > > >> > > >> Hello friends, > > >> > > >> I'm using MySQL5 on RHEL5. From the top, i understood that the CPU > > is > > >> under utlized by MySQL, whose idle time is around 37%. It is > > dedicated > > >> box > > >> for MySQL alone. Is there any way to reduce the idle time of the CPU > > or > > >> how > > >> can i make my MySQL to Utilize the full CPU time. > > >> > > >> Thanks > > >> DEVI.G > > > > > > > > > > > -------------------------------------------------------------------------------- > > > > > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: > > 10/28/2007 > > 1:58 PM > > > > > ------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.503 / Virus Database: 269.15.12/1097 - Release Date: > 10/28/2007 1:58 PM > >
