Portal Home > Knowledgebase > Articles Database > Mysql Process using too much CPU
Mysql Process using too much CPU
| Posted by rcpkrc, 08-21-2011, 07:41 AM |
| hello friends, while l check the mysql process list l see this which causing high page load.
what can l do to solve it?
|
| Posted by fabin, 08-21-2011, 07:49 AM |
| use mtop to find the queries that are causing the problem.
|
| Posted by rcpkrc, 08-21-2011, 08:41 AM |
| here is the top list of my server....
|
| Posted by fabin, 08-21-2011, 08:45 AM |
| what you need to look at is the result of "mtop", not top
http://mtop.sourceforge.net/
|
| Posted by RS-Kevin, 08-21-2011, 09:23 AM |
| You can try mysqladmin proc command to see the exact queries to exact databases which is causing these issues. It will give you the exact output and an idea of what causing the issues.
|
| Posted by rcpkrc, 08-21-2011, 10:14 AM |
| l tried to install mtop but l couldnt manage. and l dont know how to try mysqladmin proc command.
|
| Posted by rcpkrc, 08-21-2011, 10:21 AM |
| here is the mysqladmin proc list for u mate
|
| Posted by RS-Kevin, 08-22-2011, 12:20 AM |
| The database in the above post "rcpkrc_video" looks the culprit , however contact your developer who have developed the database and have them to optimize the DB , since its showing sleep status.
|
Add to Favourites 
Print this Article
Also Read
spamd child (Views: 669)
Shared Hosting
Shared Hosting
