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

Using cPanel/WHM news feature in WHM

Using cPanel/WHM news feature in WHM In order to use the cPanel and WHM news feature in WHM,...

How to manage Wheel Group Users in WHM

How to manage Wheel Group Users in WHM? In order to manage the Wheel Group Users in WHM, you...

How to manage IP addresses on your WHM server

How to manage IP addresses on your WHM server? You can manage IP address on your WHM server....

How to configure DNS Clustering across all your WHM servers

How to configure DNS Clustering across all your WHM servers? In order to configure the DNS...

How to copy multiple accounts from another server to your WHM server using SSH

How to copy multiple accounts from another server to your WHM server using SSH? In order to...