Show MySQL Processes
Valid for versions 82 through the latest version
Version:
82
Last modified: June 13, 2024
Looking for this interface?
Your hosting provider can enable or disable this interface for resellers in WHM's Edit Reseller Nameservers and Privileges interface (WHM >> Home >> Resellers >> Edit Reseller Nameservers and Privileges).
Overview
This interface lists all of the processes that currently run on any database on your server.
In cPanel & WHM version 120 and later, we renamed this interface to Show Database Processes and its section in the WHM interface to Database Services.
Process information
The interface displays this information in the following columns:
-
Id — The Process ID.
- Linux systems assign a unique process identification number to every process and application.
-
User — The user that executed the process on the database.
-
Host — The client’s hostname and the port from which the process executed. For example, Host:0000
-
db — The database on which the process runs.
- This column displays NULL if the process does not run on a database.
-
Command — The type of command that the system issued to the database.
- For more information, read MySQL’s Examining Thread Information documentation.
-
Time — The time, in seconds, that the process has remained in its current state.
-
State — The action, state, or event of the process.
- This column displays NULL for the SHOW PROCESSLIST state.
- For more information, read MySQL’s Examining Thread Information documentation.
-
Info — The text of the statement that the process currently executes.
- If the process does not execute a statement, this column displays NULL.
- This column may display a statement sent to the server, or an inner statement to execute other statements.