Re: MySQL Taking Up High CPU Resource
Below are the top results that I am getting on mysqld:
top - 13:32:15 up 2 days, 12:52, 4 users, load average: 2.40, 2.09, 2.19
Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie
Cpu0 : 46.5% us, 30.7% sy, 0.0% ni, 22.8% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu1 : 61.4% us, 27.7% sy, 0.0% ni, 10.9% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu2 : 74.3% us, 16.8% sy, 0.0% ni, 8.9% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu3 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu4 : 74.5% us, 19.6% sy, 0.0% ni, 5.9% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu5 : 1.0% us, 1.0% sy, 0.0% ni, 98.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu6 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu7 : 77.0% us, 19.0% sy, 0.0% ni, 4.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4137672k total, 2658468k used, 1479204k free, 152824k buffers
Swap: 4096532k total, 0k used, 4096532k free, 2176516k cached
PID to kill:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20886 mysql 15 0 373m 57m 3504 S 447 1.4 18:46.75 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
28190 root 17 0 2784 1016 764 S 1 0.0 0:18.39 top -d 1
20975 root 16 0 2196 1008 764 R 1 0.0 0:00.20 top -d1
1 root 16 0 2236 548 472 S 0 0.0 0:01.20 init [3]