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.
MV_ TASKS
This view provides a detailed profile of all currently running tasks on all nodes of the cluster.
It holds a row per running task.
mv_
may only be queried while connected to an aggregator node.
SingleStore recommends against extensive use of this view.
Column name |
Description |
---|---|
|
An ID equal to |
|
The |
|
An ID shared by all instances of the task’s activity. |
|
The |
|
The name of the database associated with the task’s activity, or |
|
The unique ID of the database partition associated with the task’s activity, or |
|
The full name associated with the task, or |
This view contains all extended statistics columns, including: |
|
|
A query sometimes cannot find its input data in blob cache, referred to as a cache miss. |
|
The time (milliseconds) that were spent on waiting for blob cache data. |
Last modified: October 18, 2024