Sys Schema Stored Procedures

Explore sys_schema stored procedures in MariaDB Server. These procedures simplify complex administrative and diagnostic tasks, offering streamlined access to performance and configuration insights.

create_synonym_db

The create_synonym_db stored procedure creates a new database that contains views mirroring all tables from a source database, useful for creating aliases.

optimizer_switch Helper Functions

These helper functions allow you to easily enable or disable specific optimizer_switch flags for the current session.

ps_trace_statement_digest

This procedure traces a specific statement digest in the Performance Schema, capturing details about its execution for performance analysis.

ps_trace_thread

The ps_trace_thread procedure captures a trace of Performance Schema instrumentation for a specific thread and dumps it to a .dot formatted graph file.

ps_truncate_all_tables

This procedure truncates all Performance Schema summary tables, effectively resetting all aggregated performance statistics.

statement_performance_analyzer

This diagnostic procedure creates a report of the statements currently running or recently run on the server, aiding in performance troubleshooting.

table_exists

The table_exists procedure checks for the existence of a specific table, view, or temporary table within a given database.

_{This page is licensed: CC BY-SA / Gnu FDL}