From: Devi (devivisolve.com)
Date: Mon Oct 29 2007 - 05:34:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

no.. i had an impression that the slowness can be perfectly measured only if i have very less idle CPU.. My worries how to make MySQL to utilize the fullest CPU time.. either in User/Nice mode.

Thanks
DEVI.G
  ----- Original Message -----
  From: Ananda Kumar
  To: Devi
  Cc: mysqllists.mysql.com
  Sent: Monday, October 29, 2007 3:11 PM
  Subject: Re: Under utilization of CPU by MySQL

  with this CPU load, is there any database slowness or any other issues.

  regards
  anandkl

   
  On 10/29/07, Devi <devivisolve.com> 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
      To: Devi
      Cc: mysqllists.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 <devivisolve.com> 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" <anandklgmail.com>
        To: "Devi" < devivisolve.com>
        Cc: < mysqllists.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 < devivisolve.com> 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

------------------------------------------------------------------------------

  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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]