Show MySQL Processes
Valid for versions 82 through the latest version
Version:
82
Last modified: August 9, 2022
Overview
This interface lists all of the processes that currently run on any database on your server.
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.