At 04:13 AM 10/29/2007, Devi wrote:
I'm running only MySQL in that machine. That's why i can't understand why
it consumes only 50% of CPU.
Because MySQL has to wait for the hard disk. If your table fits into
memory, then make it a memory table and CPU utilitization should increase
dramatica
Hi !
Devi 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.
Like any other user program
(as seen from the operating system point of view),
the MySQL server will use all CPU cycles it is gr
@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 t
:* 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 applicat
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
ce 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:
> Sent: Monday, October 29, 2007 1:10 PM
> Subject: Re: Unde
VI.G
- Original Message -
From: "Ananda Kumar" <[EMAIL PROTECTED]>
To: "Devi" <[EMAIL PROTECTED]>
Cc:
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% utiliz
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 wil
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.
Thank