High CPU usage ONLY by MySql !!!

[furquan]

Hello all,

My server load is quite optimal But in the "top -c" screen i see Only MySql process taking up 600% + of CPU utilization.

Can any one point me, on how do i figure this out, what is causing this issue.

The number of concurrent users is not very high either :-

[email protected] netstat -an | grep :3306 |wc -l
23

My server configuration is as follows :-

Pentium(R) Dual-Core CPU E5500 @ 2.80GHz
4 GB RAM

Any suggestion to debug this issue would be highly appreciated.

Thank you,

 

[HSN-Saman]

Search "mysql optimization" on the forum , there are many topics .
also try using mysqltuner.pl script to optimize mysql configuration.