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 > >
