Hi,
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 for
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
server.
Could you please suggest me the ways for decreasing the CPU utilization
for mysqld.exe to minimum.
Please help me in this.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
