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]