•The mysqladmin processlist  command: Section 4.5.2, “mysqladmin — A MySQL Server Administration Program” 

•The INFORMATION_SCHEMA PROCESSLIST  table: Section 26.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table” 

•The Performance Schema processlist  table: Section 27.12.21.5, “The processlist Table” 

•The Performance Schema threads  table columns with names having a prefix of PROCESSLIST_ : Section 27.12.21.6, “The threads Table” 

•The sys  schema processlist  and session  views: Section 28.4.3.22, “The processlist and x $processlist Views” , and Section 28.4.3.33, “The session and x$session Views” 

The threads  table compares to SHOW PROCESSLIST , INFORMATION_SCHEMA PROCESSLIST , and mysqladmin processlist  as follows: 

•Access to the threads  table does not require a mutex and has minimal impact on server performance. The other sources have negative performance consequences because they require a mutex. 

## Note 

As of MySQL 8.0.22, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist  table, which, like the threads  table, does not require a mutex and has better performance characteristics. For details, see Section 27.12.21.5, “The processlist Table” . 

•The threads  table displays background threads, which the other sources do not. It also provides additional information for each thread that the other sources do not, such as whether the thread is a foreground or background thread, and the location within the server associated with the thread. This means that the threads  table can be used to monitor thread activity the other sources cannot. 

•You can enable or disable Performance Schema thread monitoring, as described in Section 27.12.21.6, “The threads Table” . 

For these reasons, DBAs who perform server monitoring using one of the other thread information sources may wish to monitor using the threads  table instead. 

The sys  schema processlist  view presents information from the Performance Schema threads  table in a more accessible format. The sys  schema session  view presents information about user sessions like the sys  schema processlist  view, but with background processes filtered out. 

## Privileges Required to Access the Process List 

For most sources of process information, if you have the PROCESS  privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS  privilege), nonanonymous users have access to information about their own threads but not threads for other users, and anonymous users have no access to thread information. 

The Performance Schema threads  table also provides thread information, but table access uses a different privilege model. See Section 27.12.21.6, “The threads Table” . 

## Content of Process List Entries 

Each process list entry contains several pieces of information. The following list describes them using the labels from SHOW PROCESSLIST  output. Other process information sources use similar labels. 

