3.1 Database Processes

Displays the processlist information.

Important

This report retrieves data from the processlist view of the sys schema. If the sys schema, version 1.5.1 or higher, is not installed on the monitored MySQL server, the report is not populated.

Table 3.1 Database Processes Dashboard

Name	Description
Thread ID	The thread ID.
User	The thread user or thread name.
Command	For foreground threads, the type of command the thread is executing on behalf of the client, or Sleep if the session is idle.
Connection ID	The connection ID.
Current Statement	The statement the thread is executing, or NULL if it is not executing any statement.
Current Memory	The number of bytes allocated by the thread.
Database	The default database for the thread, or NULL if there is none.
Full Scan	The number of full table scans performed by the current statement.
Last Statement	The last statement executed by the thread, if there is no currently executing statement or wait.
Last Statement Latency	How long the last statement executed.
Last Wait	The name of the most recent wait event for the thread.
Last Wait Latency	The wait time of the most recent wait event for the thread.
Lock Latency	The time spent waiting for locks by the current statement.
PID	The client process ID.
Program Name	The client program name.
Progress	The percentage of work completed for stages that support progress reporting.
Rows Affected	The number of rows affected by the current statement.
Rows Examined	The number of rows read from storage engines by the current statement.
Rows Sent	The number of rows returned by the current statement.
Source	The source file and line number containing the instrumented code that produced the event.
State	The state for the current transaction for the thread.
Statement Latency	How long the statement has been executing.
Time	The time in seconds that the thread has been in its current state.
Tmp Disk Tables	The number of internal on-disk temporary tables created by the current statement.
Tmp Tables	The number of internal in-memory temporary tables created by the current statement.
Transaction Autocommit	Whether autocommit mode was enabled when the current transaction started.
Transaction Latency	The wait time of the current transaction for the thread.
Transaction State	The state for the current transaction for the thread.