Топ-100
 

SHOW PROCESSLIST

RDBMS Type: MySQL
Topic

Syntax:
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
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html#process
list-sources.

*Note*:

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
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-
table.html.

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.

URL: https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html

Example