MV_ PROCESSLIST
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
This view contains information about currently running threads on a cluster for all nodes.information_
shows this information per node.
Column Name |
Description |
---|---|
|
The |
|
The unique |
|
The user who issued the process command. |
|
The hostname or IP address from which the connection originated. |
|
The related database. |
|
The type of command associated with this process. |
|
The runtime, in seconds. |
|
The state of a given process. |
|
Additional information about a given process, including the query text. |
|
Low level information about this process shown as a JSON string. |
|
The |
|
|
|
The number of row locks being held. |
|
The column is deprecated, as are partition level locks. |
|
The resource pool a given process is drawing from. |
|
The reason a given process is queued. |
Last modified: July 30, 2024