MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

27.4.3.22 The processlist and x$processlist Views

These views summarize processlist information. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. By default, rows are sorted by descending process time and descending wait time.

The column descriptions here are brief. For additional information, see the description of the Performance Schema threads table at Section 26.12.18.5, “The threads Table”.

The processlist and x$processlist views have these columns: