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
Syntax optimizer_switch_on() optimizer_switch_off() optimizer_switch_choice... -
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.