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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to