I am a newbie MySQL admin and i plan to use maat script to analyze my server in some time. But at the moment i am having some issues and i hope some one can assist me.
This is a dedicated MySQL server and if you look at the CPU utilization, it is above 90% and this is my problem
top - 12:06:47 up 12 days, 4:02, 3 users, load average: 14.46, 13.09, 11.94
Tasks: 200 total, 2 running, 198 sleeping, 0 stopped, 0 zombie
Cpu(s): 92.6%us, 2.7%sy, 0.0%ni, 4.4%id, 0.0%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 32945432k total, 4790872k used, 28154560k free, 107364k buffers
My MySQL server specs are as follows :-
Mysql ver :- mysql Ver 14.14 Distrib 5.1.61
DB Engine = INNODB
DB size = 7.9MB
DB Rows = 580
I just have one Db that is being continuously hammered by number of users, For reference i am attaching the “show processlist” txt file attached along with this message.
Can any one please go through it and suggest me what can i do to get the load down on the Db ?