If incase MySQL works with high load and I/O on whm/cpanel server. Is there a way to check which MySQL user is responsible for it?
If incase MySQL works with high load and I/O on whm/cpanel server. Is there a way to check which MySQL user is responsible for it?
Yes, you can check this from the MySQL's inbuilt command called "mysqladmin processlist", which displays the exact amount of queries being fired/executed at that moment. You can check the exact user which is causing overloading issues (using most resources (CPU/MEM)) for MySQL from the WHM interface from Main >> System Health >> Show Current CPU Usage.
Rock _a.k.a._ Jack
Windows Hosting || Windows Reseller Hosting
Cloud Hosting || Powerful Dedicated Servers
Follow eUKhost on Twitter || Join eUKhost Community on Facebook
For complaints, grievances or suggestions kindly email our FeedBack Dept.
Proper action will be taken accordingly & instantaneously!
There are currently 1 users browsing this thread. (0 members and 1 guests)