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

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 <devi@visolve.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

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" <anandkl@gmail.com>
To: "Devi" <devi@visolve.com>
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 <devi@visolve.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

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 <devi@visolve.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" <anandkl@gmail.com>
> To: "Devi" <devi@visolve.com>
> 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 <devi@visolve.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
>
>

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 <devi@visolve.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" <anandkl@gmail.com>
To: "Devi" <devi@visolve.com>
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 < devi@visolve.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

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

regards
anandkl


On 10/29/07, Devi <devi@visolve.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 <anandkl@gmail.com>
> *To:* Devi <devi@visolve.com>
> *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 <devi@visolve.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" <anandkl@gmail.com>
> > To: "Devi" <devi@visolve.com>
> > 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 < devi@visolve.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.. 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 <devi@visolve.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: 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 <devi@visolve.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" <anandkl@gmail.com>
To: "Devi" < devi@visolve.com>
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 < devi@visolve.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

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 granted by the OS if

1) it has got tasks to do (commands from the application clients) *and*

2) it has got the necessary data available.


For 1), check your client machines and the network: If they cannot
produce or transfer the commands as fast as the server can handle them,
the server will have idle times.


For 2), check the amount of "waiting for I/O": If the database server
started some I/O operation, it may have to wait for that to finish
before it can continue.


>
> I mean only if MySQL utilizes the full CPU, i can estimate the performance of MySQL for different Client Applications.

This depends on the type of environment you are checking:
If you had an infinitely fast CPU, you would always be limited by the
disks (even if all data were in RAM, you could not change them faster
then your log writing speed), so there are situations where a 100 % CPU
usage would imply either a slow CPU or bad code.


HTH,
Joerg

--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
Office: (+49 30) 417 01 487 VoIP: 4464@sip.mysql.com

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
dramatically (less wait time). Or you can try and get a faster hard drive,
defrag it, optimize your tables, and buy faster controller card and if
you're using it over a network, get a faster network card.

Mike