# Sys Schema

- [Sys Schema sys\_config Table](/docs/server/reference/system-tables/sys-schema/sys-schema-sys_config-table.md)
- [Sys Schema Stored Functions](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions.md): Explore sys\_schema stored functions in MariaDB Server. These functions simplify querying performance and configuration data, offering a user-friendly interface for database diagnostics.
- [extract\_schema\_from\_file\_name](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/extract_schema_from_file_name.md)
- [extract\_table\_from\_file\_name](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/extract_table_from_file_name.md)
- [format\_path](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_path.md)
- [format\_statement](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_statement.md)
- [format\_time](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_time.md)
- [list\_add](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/list_add.md)
- [list\_drop](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/list_drop.md)
- [ps\_is\_account\_enabled](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_account_enabled.md)
- [ps\_is\_consumer\_enabled](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_consumer_enabled.md)
- [ps\_is\_instrument\_default\_enabled](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_instrument_default_enabled.md)
- [ps\_is\_instrument\_default\_timed](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_instrument_default_timed.md)
- [ps\_is\_thread\_instrumented](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_thread_instrumented.md)
- [ps\_thread\_account](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_account.md)
- [ps\_thread\_id](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_id.md)
- [ps\_thread\_stack](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_stack.md)
- [ps\_thread\_trx\_info](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_trx_info.md)
- [quote\_identifier](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/quote_identifier.md)
- [sys\_get\_config](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/sys_get_config.md)
- [format\_bytes](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/sys_schema_format_bytes.md)
- [version\_major](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_major.md)
- [version\_minor](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_minor.md)
- [version\_patch](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_patch.md)
- [Sys Schema Stored Procedures](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures.md): 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](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/create_synonym_db.md)
- [optimizer\_switch Helper Functions](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/optimizer_switch-helper-functions.md)
- [ps\_trace\_statement\_digest](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/ps_trace_statement_digest.md)
- [ps\_trace\_thread](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/ps_trace_thread.md)
- [ps\_truncate\_all\_tables](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/ps_truncate_all_tables.md)
- [statement\_performance\_analyzer](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/statement_performance_analyzer.md)
- [table\_exists](/docs/server/reference/system-tables/sys-schema/sys-schema-stored-procedures/table_exists.md)
- [Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views.md): Explore sys\_schema views in MariaDB Server. These views offer simplified, aggregated insights into server performance, I/O, and memory usage, making diagnostics and monitoring easier.
- [host\_summary and x$host\_summary Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary-and-xhost_summary-sys-schema-views.md)
- [host\_summary\_by\_file\_io and x$host\_summary\_by\_file\_io Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_file_io-and-xhost_summary_by_file_io-sys-schema-views.md)
- [host\_summary\_by\_file\_io\_type and x$host\_summary\_by\_file\_io\_type Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_file_io_type-and-xhost_summary_by_file_io_type-sys-schema-v.md)
- [host\_summary\_by\_stages and x$host\_summary\_by\_stages Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_stages-and-xhost_summary_by_stages-sys-schema-views.md)
- [host\_summary\_by\_statement\_type and x$host\_summary\_by\_statement\_type Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_statement_type-and-xhost_summary_by_statement_type-sys-sche.md)
- [innodb\_buffer\_stats\_by\_schema and x$innodb\_buffer\_stats\_by\_schema Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_buffer_stats_by_schema-and-xinnodb_buffer_stats_by_schema-sys-schema.md)
- [innodb\_buffer\_stats\_by\_table and x$innodb\_buffer\_stats\_by\_table Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_buffer_stats_by_table-and-xinnodb_buffer_stats_by_table-sys-schema-v.md)
- [innodb\_lock\_waits and x$innodb\_lock\_waits Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_lock_waits-and-xinnodb_lock_waits-sys-schema-views.md)
- [io\_by\_thread\_by\_latency and x$io\_by\_thread\_by\_latency Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_by_thread_by_latency-and-xio_by_thread_by_latency-sys-schema-views.md)
- [io\_global\_by\_file\_by\_bytes and x$io\_global\_by\_file\_by\_bytes Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_file_by_bytes-and-xio_global_by_file_by_bytes-sys-schema-views.md)
- [io\_global\_by\_file\_by\_latency and x$io\_global\_by\_file\_by\_latency Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_file_by_latency-and-xio_global_by_file_by_latency-sys-schema-v.md)
- [io\_global\_by\_wait\_by\_bytes and x$io\_global\_by\_wait\_by\_bytes Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_wait_by_bytes-and-xio_global_by_wait_by_bytes-sys-schema-views.md)
- [io\_global\_by\_wait\_by\_latency and x$io\_global\_by\_wait\_by\_latency Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_wait_by_latency-and-xio_global_by_wait_by_latency-sys-schema-v.md)
- [latest\_file\_io and x$latest\_file\_io Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/latest_file_io-and-xlatest_file_io-sys-schema-views.md)
- [memory\_by\_host\_by\_current\_bytes and x$memory\_by\_host\_by\_current\_bytes Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/memory_by_host_by_current_bytes-and-xmemory_by_host_by_current_bytes-views.md)
- [metrics Sys Schema View](/docs/server/reference/system-tables/sys-schema/sys-schema-views/metrics-sys-schema-view.md)
- [privileges\_by\_table\_by\_level Sys Schema View](/docs/server/reference/system-tables/sys-schema/sys-schema-views/privileges_by_table_by_level-sys-schema-view.md)
- [schema\_auto\_increment\_columns Sys Schema View](/docs/server/reference/system-tables/sys-schema/sys-schema-views/schema_auto_increment_columns-sys-schema-view.md)
- [schema\_object\_overview Sys Schema View](/docs/server/reference/system-tables/sys-schema/sys-schema-views/schema_object_overview-sys-schema-view.md)
- [host\_summary\_by\_statement\_latency and x$host\_summary\_by\_statement\_latency Sys Schema Views](/docs/server/reference/system-tables/sys-schema/sys-schema-views/sys-schema-views-host_summary_by_statement_latency-and-xhost_summary_by_sta.md)
