We are using the same set of query's what we re using in some
other process, where the mysqld CPU utilization is minimum. But for this
process particularly, mysqld is utilising more than 90 % of CPU. Even in
2GB RAM machine also, behaving same. We are using Windows XP/ 2000/ 2003
server. In all these it is behaving like this. Could any one of you
suggest me the way to handle this situation.
From: SGreen@stripped [mailto:SGreen@stripped]
Sent: Monday, September 26, 2005 9:43 PM
To: Lakshmi NarasimhaRao (WT01 - Voice & Next Generation Networks)
Cc: gleb.paharenko@stripped; mysql@stripped
Subject: Re: Regarding the cpu utilization of mysqld
<lakshmi.narasimharao@stripped> wrote on 09/26/2005 11:50:11 AM:
> When running a process which is a part of my apllication,
> mysqld.exe is using 90%-95% of cpu utilization. Here I used mysqld for
> starting the mysql server. For other processes in the application, CPU
> utilization is very minimum. I used optimization (for order by, select
> and like) in building the sql queries used by the process and modified
> the following parameters in the my.ini file as
> key_buffer = 64M
> max_allowed_packet = 1M
> sort_buffer_size = 4M
> read_buffer_size = 4M
> query_cache_size= 16M
> I am using 256MB RAM. Are my above modifications are correct/useful
> minimizing the CPU utilization?. Even after this also mysqld is using
> around 85% of CPU.
> Are there any other ways for minimizing the cpu utilization for mysql
> Could you please suggest me the ways for decreasing the CPU
> for mysqld.exe to minimum.
> Please help me in this.
Is it conceivable that the MySQL server could actually be that busy? How
many SQL statements are you processing per second? How much data is
transferring into and out of your MySQL server? What are some of the
queries appearing in your slow query log? What do the EXPLAINs if those
queries tell you? Besides MySQL, what else does that server host? What
operating system is on that server? How much memory have you allocated
for MySQL usage (some OS's allow for per-appication memory tuning)?
Depending on what else is going on or how much memory all of your other
applications/daemons have taken up, MySQL could be spending all of your
CPU time just paging data. 256MB is not very much memory to install for
a database server, especially a shared database server. May I suggest
that you add more RAM (at least upgrade to 1GB RAM, more if you can
Unimin Corporation - Spruce Pine
The information contained in this electronic message and any attachments to this message
for the exclusive use of the addressee(s) and may contain confidential or privileged
you are not the intended recipient, please notify the sender at Wipro or
and destroy all copies of this message and any attachments.