Топ-100
 
CerebroSQL

SHOW PROCESSLIST

Database: MySQL

68747470733a2f2f7374796c65732e7265646469746d656469612e636f6d2f74355f32716d366b2f7374796c65

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.

*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.

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.

Example