Re: Under utilization of CPU by MySQL

[Devi]

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 
  To: Devi 
  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