Sys Schema Stored Procedures
This article is currently incomplete.
The following stored procedures are available in the Sys Schema.
-
create_synonym_db
Takes a source db and create a synonym db with views that point to all of t... -
optimizer_switch Helper Functions
Quickly see which optimizer_switch options are on or off -
ps_trace_statement_digest
Traces all Performance Schema instrumentation for a specific statement digest. -
ps_trace_thread
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file. -
ps_truncate_all_tables
Resets all aggregated instrumentation. -
statement_performance_analyzer
Returns a report on running statements. -
table_exists
Given a database and table name, returns the table type.
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.
