SHOW Statements Stored routine information is also available from the  INFORMATION_SCHEMA PARAMETERS  and  ROUTINES tables. See Section 26.3.20, “The INFORMATION_SCHEMA PARAMETERS Table” , and Section 26.3.30, “The INFORMATION_SCHEMA ROUTINES Table” . SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The  SHOW PROCESSLIST  statement is one source of process information. For a comparison of this statement with other sources, see Sources of Process Information. As of MySQL 8.0.22, an alternative implementation for  SHOW PROCESSLIST  is available based on the Performance Schema  processlist  table, which, unlike the default  SHOW PROCESSLIST  implementation, does not require a mutex and has better performance characteristics. For details, see Section 27.12.21.5, “The processlist Table” . 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. Without the  FULL  keyword,  SHOW PROCESSLIST  displays only the first 100 characters of each statement in the  Info  field. The  SHOW PROCESSLIST  statement is very useful if you get the “too many connections”  error message and want to find out what is going on. MySQL reserves one extra connection to be used by accounts that have the  CONNECTION_ADMIN  privilege (or the deprecated  SUPER  privilege), to ensure that administrators should always be able to connect and check the system (assuming that you are not giving this privilege to all your users). Threads can be killed with the  KILL  statement. See Section 13.7.8.4, “KILL Statement” . Example of  SHOW PROCESSLIST  output: 2942 13.7.7.29 SHOW PROCESSLIST Statement Note mysql> SHOW FULL PROCESSLIST\G *************************** 1. row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: Waiting for master to send event Info: NULL *************************** 2. row *************************** Id: 2 User: system user Host: db: NULL Command: Connect Time: 1004 State: Has read all relay log; waiting for the slave I/O thread to update it Info: NULL *************************** 3. row *************************** Id: 3112 User: replikator Host: artemis:2204 db: NULL