Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Shows details about currently running threads.
SHOW PROCESSLIST;
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 the information_schema.processlist
table directly.Info
column’s data is affected by whether the global variable show_query_parameters
is set to ON
or OFF
. By default, show_query_parameters
is set to ON
, which results in Info
field containing the plain text of a query, including query parameters. If show_query_parameters
is set to OFF
, the Info
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 to OFF
, 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 SingleStore DB 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 |
RPC Info |
Low level information about this process shown as a JSON string |
SHOW PROCESSLIST;
+----+------+-----------------+------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | RPC Info |
+----+------+-----------------+------+---------+------+-------+------------------+----------+
| 19 | root | localhost:33790 | test | Query | 1118 | NULL | SHOW PROCESSLIST | {} |
+----+------+-----------------+------+---------+------+-------+------------------+----------+
1 row in set (0.00 sec)