mysql sucking too much cpu.. unusual

root@sv2 [~]# ps -fu mysql
UID PID PPID C STIME TTY TIME CMD
mysql 2223 1231 0 05:19 ? 00:00:00
mysql 2244 1231 0 05:19 ? 00:00:01
mysql 2265 1231 29 05:19 ? 00:20:52
mysql 2286 1231 0 05:19 ? 00:00:00


you notice that biggest cpu usage have process with largest C column whatever this is? I got some servers with same configuration (2,4 GHz) and that only one acting like this. CPU usage goes to 50% with only Queries per second avg: 34.047 on this server. servers with same configuration with 400 per second dont use 1/10 of that cpu time

times mysqladmin processlist does not support usung so much cpu at all

Anyone can suggest something?

 

 

 

 

Top