Sys Schema Stored Procedures
This article is currently incomplete.
The following stored procedures are available in the Sys Schema.
| Title | Description |
|---|---|
| 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.
© 2023 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/sys-schema-stored-procedures/