Accessing the Process List •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. 1844