In MySQL, the sys.format_path() function is a stored function in the sys schema. It accepts a path name, and returns the modified path name after replacing subpaths that match the values of certain system variables.
So we can use the function to dynamically replace part or all of our path with a system variable that matches that path segment.
Continue readingIn MySQL, the sys.extract_table_from_file_name() function is a stored function in the sys schema.
It accepts a path name, and returns the path component that represents the table name.
Continue readingIn MySQL, we can use the sys.ps_is_account_enabled() function to check whether Performance Schema instrumentation for a given account is enabled.
The function returns YES or NO, depending on whether or not the instrumentation for the given account is enabled.
In MySQL, the sys.ps_thread_account() function returns the account associated with a given thread ID. It returns the account in the form user_name@host_name.
In MySQL, we can use the sys.ps_is_instrument_default_enabled() function to check whether a given Performance Schema instrument is enabled by default.
The function returns YES or NO, depending on whether the instrument is enabled by default.
In MySQL, we can use the sys.ps_is_instrument_default_timed() function to check whether a given Performance Schema instrument is timed by default.
The function returns YES or NO, depending on whether the instrument is timed by default.
In MySQL, we can use the sys.ps_is_thread_instrumented() function to check whether Performance Schema instrumentation for a given connection ID is enabled.
The function returns YES or NO, depending on whether the instrumentation is enabled for the given connection. It can also return UNKNOWN if the connection ID is unknown, and NULL if the connection ID is NULL.
In MySQL, we can use the sys.version_patch() function to return the patch release version of the MySQL server.
For example, if we’re using MySQL 8.0.33, sys.version_patch() returns 33.
In MySQL, we can use the sys.version_minor() function to return the minor release version of the MySQL server.
In MySQL, we can use the sys.version_major() function to return the major release version of the MySQL server.