Outdated Version
You are viewing an older version of this section. View current production version.
SHOW PROCESSLIST
Shows details about currently running threads.
Syntax
SHOW PROCESSLIST
Remarks
- This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
- This command exposes a formatted subset of data in the
information_schema.processlist
table. Additionally,SHOW PROCESSLIST
output may truncate data from this table. To see all possible fields and the complete field text, query theinformation_schema.processlist
table directly. - The
Info
column’s data is affected by whether the global variableshow_query_parameters
is set toON
orOFF
. By default,show_query_parameters
is set toON
, which results inInfo
field containing the plain text of a query, including query parameters. Ifshow_query_parameters
is set toOFF
, theInfo
field will only contain the parameterized query text. show_query_parameters
is used in cases when access to sensitive data–in this case, query parameters–needs to be restricted. If this variable is set toOFF
, parameters will be hidden. This can be set only at startup, not during runtime; it must be set in the memsql.cnf, followed by a system restart.
Output
Column | Description |
---|---|
Id |
Process ID |
User |
User associated with this process. |
Host |
Host name or IP address and port number |
db |
Name of MemSQL database |
Command |
Type of command associated with this process |
Time |
Time (in seconds) |
State |
Process state |
Info |
Additional information about this process, including the query text. |
Example
memsql> SHOW PROCESSLIST;
+----+------+-----------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------------+------+---------+------+-------+------------------+
| 19 | root | localhost:33790 | test | Query | 1118 | NULL | SHOW PROCESSLIST |
+----+------+-----------------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)