Trace Event Commands
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.
On this page
CREATE EVENT TRACE
Creates a trace event.
Syntax
CREATE EVENT TRACE
event_name
[ WITH (<event_characteristic>, ...) ];
Where <event_
is an key/value pair, such as:
-
Query_
captures the query texttext = on -
Duration_
traces all queries with runtimes over 1 secondthreshold_ ms = 1000 -
Trace_
traces all queries that have failed, even when their runtimes are less thanall_ failed_ executions= on Duration_
threshold_ ms
Remarks
-
The
event_
andname event_
keys are not case-sensitive.characteristic -
Currently,
Query_
is the only usable event type.completion -
The ALTER TRACE permission is required to create trace events.
-
Since
event_
key-value pairs are optional, each event trace has its own default values for a default configuration.characteristic
DROP EVENT TRACE
Drops a trace event.
Syntax
DROP EVENT TRACE event_name;
Remarks
-
The
ALTER TRACE
permission is required to drop trace events.
Last modified: July 29, 2024