Show MySQL® Processes

log in to your WHM>>SQL Services>>Show MySQL® Processes

First, you need to log into the WHM service for your VPS or Dedicated Server. If you are not sure how to do that, please check our How to access the WHM service tutorial. After you have logged in, please use the search bar on the left side of the page and type “Show MySQL Processes”.

When the functionality presents itself below the search bar, please click on the “Show MySQL Processes” link.

Viewing the MySQL processes on your server

This will redirect you to the “Show MySQL Processes” page immediately.

Upon going to the ”Show MySQL Processes” page, you will see a table section containing columns with the following information:

• Id – This column will display the process ID. In Linux, unique identification numbers are assigned to each process an application or a service spawns.
• User – This column will contain the user that executed the process.
• Host – This column will display the hostname from which the user triggered the process. Additionally, it may also contain a port and it will be represented like 127.0.0.1:1234 or armadaservers.com:4321.
• db – This will display the database for which the process is currently running.
• Command – This will be the type of command, which the application/system/service executed and was sent to the database.
• Time – This column will show the time in seconds in which the process has remained in its current state.
• State – This shows the current state of the process. Usually, a process should remain in a given state for a very short period of time. If you notice that a process is spending more than 2-3 seconds in a specific state, there is most likely a problem with the service or application which spawned it.
• Info – This column will contain the text of the statement which is being executed. It may contain the first 100 characters of an SQL query.