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

If you've 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) Go to the SQL Services menu.


2) Click Show MySQL Processes.


 

Here, you'll see a list of all the processes currently in use by MySQL. You can use the process IDs in this list to kill the processes, if necessary. That's beyond the scope of this tutorial, though.


 

This table indicates the user and host performing the action on which database, what kind of command they're running, the amount of time it's been in progress, its current state, and some additional information about the process.

 

This is the end of the tutorial. You now know how to view the MySQL Process List in WHM.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

An overview of the important services that keep your WHM server running

Services are crucial to any web server's operation. To the end-user, these programs work together...

How to access phpMyAdmin from WHM

phpMyAdmin is a widely-used database tool that happens to come with all cPanel and WHM...

How to access your WHM server's bandwidth monitoring system (bandmin)

Bandmin is a bandwidth monitoring system installed by default on Linux cPanel/WHM servers. It...

How to add MySQL access hosts in WHM

When granting a MySQL user access to a database, you have to specify which hosts are allowed to...

How to change the bandmin username and password in WHM

Bandmin is a bandwidth monitoring system installed by default on Linux cPanel/WHM servers. It...