Knowledgebase

Portal Home > Knowledgebase > Articles Database > MySQL thrashing

MySQL thrashing

Posted by kshazad86, 03-18-2012, 08:34 AM

If MySQL is being thrashed on my shared server (cPanel/CentOS). What is the fastest way to find out which user is consuming the most mySQL CPU usage?

---

Posted by iTom, 03-18-2012, 09:01 AM

Have a look at mytop - http://jeremy.zawodny.com/mysql/mytop/ You might also want to temporarily enable mysql slow query log

---

Posted by kshazad86, 03-18-2012, 09:19 AM

Thanks for this, I've managed to install mytop, but can you tell me the command for viewing the mysql queries for ALL users on the system with this tool? Also, how can I change the permissions of mytop so that it is only accessible by root?

---

Posted by HandsUpBr, 03-18-2012, 10:07 AM

Thanks, i will try this.

---

Add to Favourites    Print this Article

DemoWolf now providing Flash Tutorials to over 550 web hosting companies (Views: 800)

EXT3 File System corrupt - I'm screwed and going to shoot myself?! (Views: 683)

Problem with my reseller account - URGENT (Views: 723)

Recommendations (Views: 722)

How to know if im hosted on a VPS or Dedicated Server? (Views: 691)