I am very new to linux server .I am using centos.Sometimes my cpu gets overloaded because of the process mysqld over 100%
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2221 mysql 20 0 2810m 797m 5648 S 99.3 5.0 262:15.91 mysqld
So To debug I ran top command in ssh and I got below
Cpu(s): 2.9%us, 2.3%sy, 0.0%ni, 94.7%id, 0.0%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 16291440k total, 14893024k used, 1398416k free, 1673232k buffers
Swap: 16433144k total, 30168k used, 16402976k free, 10713048k cached
I dont understand anything in this but i see , Only one CPU (94.7%id) is used alot and other CPU are free.How to make mysql to share more cpu and reduce the load.
94.7%id
means the system spends 94.7% of its time doing nothing (id=idle).