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;

Notes

Example


  1. No comments yet.
  1. No trackbacks yet.