Show MySQL Processes

Show MySQL Process

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:

Column
Description
Notes
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 Informationdocumentation.
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 Informationdocumentation.
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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Additional MySQL Access Hosts

Additional MySQL Access Hosts This interface allows you to permit remote hosts (servers) to...

Change MySQL User Password

Change MySQL User Password This interface allows you to change a database user's password....

Database Map Tool

Database Map Tool This feature allows server administrators to grant ownership of database...

MySQL Root Password

MySQL Root Password This interface allows you to set the MySQL® root password. Warnings:...

Manage MySQL® Profiles

  Manage MySQL® Profiles This interface allows you to manage multiple MySQL® server profiles. A...