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: mysql@lists.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 <[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
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
------------------------------------------------------------------------------
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
