How to see details in WHM about the processes currently in use by MySQL

How to see details in WHM about the processes currently in use by MySQL?

If you have noticed that MySQL seems to be responding sluggishly, one of your users may be running something that’s taking up a lot of resources.

  1. Login to WHM account and then go to the SQL Services menu.
  2. Click Show MySQL processes. You will get a list of all the processes currently in use by MySQL. You can use the process IDs in the list to kill the processes, if necessary.
  3. The table indicates the user and host performing the action on which database, what kind of command they are running, and the amount of time it’s been in progress, its current state and some additional information about the process.

 

  • 33 Users Found This Useful
Was this answer helpful?

Related Articles

How to create a new cPanel account in WHM

How to create a new cPanel account in WHM? To create a new cPanel account in WHM here below are...

How to access cPanel accounts through WHM

How to access cPanel accounts through WHM? In order to access cPanel accounts through WHM, here...

How to change an accounts password in WHM

How to change an account's password in WHM? In order to modify an account password in WHM, you...

How to change an accounts disk quota in WHM

How to change an account's disk quota in WHM? Remember that some webhosts want their clients to...

How to see a list of all the accounts over their disk quotas in WHM

How to see a list of all the accounts over their disk quotas in WHM? Occasionally, some of the...