> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions.md).

# Sys Schema Stored Functions

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](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/extract_schema_from_file_name.md)
* [extract\_table\_from\_file\_name](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/extract_table_from_file_name.md)
* [format\_bytes](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/sys_schema_format_bytes.md)
* [format\_path](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_path.md)
* [format\_statement](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_statement.md)
* [format\_time](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_time.md)
* [list\_add](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/list_add.md)
* [list\_drop](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/list_drop.md)
* [ps\_is\_account\_enabled](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_account_enabled.md)
* [ps\_is\_consumer\_enabled](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_consumer_enabled.md)
* [ps\_is\_instrument\_default\_enabled](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_instrument_default_enabled.md)
* [ps\_is\_instrument\_default\_timed](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_instrument_default_timed.md)
* [ps\_is\_thread\_instrumented](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_thread_instrumented.md)
* [ps\_thread\_account](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_account.md)
* [ps\_thread\_id](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_id.md)
* [ps\_thread\_stack](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_stack.md)
* [ps\_thread\_trx\_info](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_trx_info.md)
* [quote\_identifier](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/quote_identifier.md)
* [sys\_get\_config](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/sys_get_config.md)
* [version\_major](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_major.md)
* [version\_minor](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_minor.md)
* [version\_patch](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_patch.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}
