MV_ TRACE_ EVENTS_ STATUS
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.
The MV_
information schema view can be used to view the status of current trace events.MV_
.
The LMV will return a row for each trace event that either:
-
Has at least one entry in the buffer -- or --
-
Is currently active
This means that trace events that are disabled and have no more entries in the buffer will not show up in the LMV.CREATION_
and CONFIGURATION
columns always return NULL
whenever ACTIVE
is NO
.
This view also has two columns, TOTAL_
and UNCONSUMED_
used to track total events traced since creation time and total events that were evicted without having been retrieved since creation time.MV_
.
Column Name |
Description |
Column Type |
---|---|---|
|
The ID of the SingleStore node |
|
|
The IP address of the SingleStore node |
|
|
The type of node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF) |
|
|
The type of event that is traced, where |
|
|
If the trace event is active |
|
|
The time the event configuration was created |
|
|
The way the user configured it in the |
|
|
Current memory, in bytes, used by all event traces of this |
|
|
Total number of events traced of this |
|
|
Total number of events of |
|
Last modified: December 19, 2023