<[EMAIL PROTECTED]> wrote on 09/26/2005 11:50:11 AM: > > 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 >
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 afford it). Shawn Green Database Administrator Unimin Corporation - Spruce Pine
