Show MySQL Processes

This feature is a list of any processes that are currently being run on any database on your server.

The information is divided into 8 columns.

The columns are:

• Id — Process ID of the process being run.
  • In a *nix system, every process and application is assigned a unique process identification number so that it is easy to identify.
• User — The user executing the process on the database.
• Host — The hostname of the client and the port that the process is being executed from.
  • Example: Host:0000
• db — The database on which the process is being run.
  • NULL will be displayed if no database is selected.
• Command — The type of command that was issued to the database.
  • For more information on this column, visit the MySQL documentation at http://dev.mysql.com/doc/refman/5.0/en/thread-information.html.
• Time — The time, in seconds, that the process has been in its current state.
• State — The action, state, or event of the process.
  • NULL will be displayed for the SHOW PROCESSLIST state.
  • For more information on this column, visit the MySQL documentation at http://dev.mysql.com/doc/refman/5.0/en/thread-information.html.
• Info — The text of the statement that the process is executing.
  • NULL will be displayed if no statement is being executed.
  • This information may be a statement sent to the server, or an inner statement to execute other statements.