Outdated Version
You are viewing an older version of this section. View current production version.
SHOW PROCESSLIST
Shows details about currently running threads.
SHOW PROCESSLIST
Notes
- This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
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 |
State |
Process state |
Info |
Additional information about this process |
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)
