Show Database Processes

databases whmui mysql

Valid for versions 120 through the latest version

Last modified: June 13, 2024

Looking for this interface?

Note:

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.

Note:

In cPanel & WHM version 118 and earlier, we titled this interface Show MySQL Processes and its section in the WHM interface SQL Services.

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 about MySQL Command entries, read MySQL’s Examining Thread Information documentation.
Time — The time that the process has remained in its current state in seconds.
State — The action, state, or event of the process.
- This column displays NULL for the SHOW PROCESSLIST state.
- For more information about MySQL State entries, 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 that executes other statements.