Processlist
Description
The SHOW [FULL] PROCESSLIST command provides a list of currently connected connections. The output includes the details of any running SQL statements. Without the FULL keyword, only a subset of the SQL statement is shown.
This command can be used as one means of capturing some SQL statements executed against the MySQL server however this approach is a catch in the act method and is not accurate for determining a full list of executed SQL Statements.
Syntax
MySQL/MariaDB
mysql> SHOW FULL PROCESSLIST;
$ mysqladmin -v processlist
Drizzle
drizzle> SHOW FULL PROCESSLIST;