ps_trace_statement_digest

You are viewing an old version of this article. View the current version here.

Syntax

ps_trace_statement_digest(in_digest, in_runtime, in_interval, in_start_fresh, in_auto_enable) 

Description

ps_trace_statement_digest is a stored procedure available with the Sys Schema.

Parameters:

  • in_digest VARCHAR(32): The statement digest identifier to analyze.
  • in_runtime INT: Specifies the duration to run the analysis in seconds.
  • in_interval DECIMAL(2,2): The analysis interval measured in seconds (including fraction values), at which snapshots are taken.
  • in_start_fresh BOOLEAN: Determines whether to truncate the Performance Schema events_statements_history_long and events_stages_history_long tables before starting.
  • in_auto_enable BOOLEAN: Determines whether to automatically enable required consumers.

Examples

<<sql>> CALL sys.ps_trace_statement_digest('891ec6860f98ba46d89dd20b0c03652c', 5, 0.5, TRUE, TRUE);

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.