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

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)