The MySQL process list indicates the operations currently
being performed by the set of threads executing within the
x$processlist views summarize
process information. They provide more complete information
statement and the
PROCESSLIST table, and are also
nonblocking. By default, rows are sorted by descending process
time and descending wait time. For a comparison of process
information sources, see
Sources of Process Information.
The column descriptions here are brief. For additional
information, see the description of the Performance Schema
threads table at
Section 126.96.36.199, “The threads Table”.
x$processlist views have these
The thread ID.
The connection ID.
The thread user or thread name.
The default database for the thread, or
NULLif there is none.
For foreground threads, the type of command the thread is executing on behalf of the client, or
Sleepif the session is idle.
An action, event, or state that indicates what the thread is doing.
The time in seconds that the thread has been in its current state.
The statement the thread is executing, or
NULLif it is not executing any statement.
The query execution engine. The value is either
SECONDARY. For use with MySQL Database Service and HeatWave, where the
SECONDARYengine is HeatWave (
RAPID). For MySQL Community Edition Server, MySQL Enterprise Edition Server (on-premise), and MySQL Database Service without HeatWave, the value is always
PRIMARY. This column was added in MySQL 8.0.29.
How long the statement has been executing.
The percentage of work completed for stages that support progress reporting. See Section 28.3, “sys Schema Progress Reporting”.
The time spent waiting for locks by the current statement.
The time spent on CPU for the current thread.
The number of rows read from storage engines by the current statement.
The number of rows returned by the current statement.
The number of rows affected by the current statement.
The number of internal in-memory temporary tables created by the current statement.
The number of internal on-disk temporary tables created by the current statement.
The number of full table scans performed by the current statement.
The last statement executed by the thread, if there is no currently executing statement or wait.
How long the last statement executed.
The number of bytes allocated by the thread.
The name of the most recent wait event for the thread.
The wait time of the most recent wait event for the thread.
The source file and line number containing the instrumented code that produced the event.
The wait time of the current transaction for the thread.
The state for the current transaction for the thread.
Whether autocommit mode was enabled when the current transaction started.
The client process ID.
The client program name.