Valid for versions 82 through the latest version
Version:
82
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.
