Product Solutions Support
Try MemSQL

SHOW PROCESSLIST

Shows details about currently running threads.

Syntax

SHOW PROCESSLIST

Remarks

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, 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)
Was this article useful?