Sys Schema Stored Functions
The following stored functions are available in the Sys Schema.
-
extract_schema_from_file_name
Returns the schema (database) name. -
extract_table_from_file_name
Returns the table name from the provided path. -
format_bytes
Returns a string consisting of a value and the units in a human-readable format. -
format_path
Returns a modified path, replacing subpaths matching the values of various system variables. -
format_statement
Returns a reduced length string. -
format_time
Given a time in picoseconds, returns a human-readable time and unit. -
list_add
Takes a list to be be modified and a value to be added to the list, returning the resulting value. -
list_drop
Takes a list to be be modified and a value to be dropped, returning the resulting value. -
ps_is_account_enabled
Whether or not Performance Schema instrumentation for a given account is enabled. -
ps_is_consumer_enabled
Whether or not Performance Schema instrumentation for a given consumer is enabled. -
ps_is_instrument_default_enabled
Whether or not a Performance Schema instrument is enabled by default. -
ps_is_instrument_default_timed
Whether or not a Performance Schema instrument is timed by default. -
ps_is_thread_instrumented
Whether or not instrumentation for a given connection_id is enabled. -
ps_thread_account
Returns the account associated with the given thread_id. -
ps_thread_id
Returns the thread_id associated with the given connection_id. -
ps_thread_stack
Returns statements, stages, events within the Performance Schema for a given thread_id. -
ps_thread_trx_info
Returns a JSON object with information about the thread specified by the given thread_id. -
quote_identifier
Returns quoted, properly escaped identifier. -
sys_get_config
Returns a configuration option value from the sys_config table. -
version_major
Returns the MariaDB Server major release version. -
version_minor
Returns the MariaDB Server minor release version. -
version_patch
MariaDB Server patch release version.
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.
