X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2025 MariaDB. All rights reserved.

The Ultimate Guide to High Availability with MariaDB
Download Now
  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Solutions
  • Resources
  • Company
  • Pricing
  • Download
Knowledge Base » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements » Administrative SQL Statements » System Tables » Sys Schema » Sys Schema Stored Procedures
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here

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.
  • ← Sys Schema Stored Functions
  • ↑ Sys Schema ↑
  • Sys Schema Views →
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.
  • ↑ Sys Schema ↑
  • Sys Schema sys_config Table
  • Sys Schema Stored Functions
  • Sys Schema Stored Procedures
  • Sys Schema Views
  • Products
  • Solutions
  • Resources
  • Company
  • Pricing
  • Download MariaDB
Subscribe to our newsletter!
  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2025 MariaDB. All rights reserved.