MySQL:
SHOW PROCESSLIST
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