126.96.36.199 The processlist and x$processlist Views
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The
x$processlist views summarize process information. They provide more complete information than the
SHOW PROCESSLIST 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 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.
How long the statement has been executing.
The percentage of work completed for stages that support progress reporting. See Section 26.3, “sys Schema Progress Reporting”.
The time spent waiting for locks by the current statement.
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.