Search Results
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely related. There might be several instances of a given type of structured ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to reuse. Thus, this procedure is useful primarily for executing dynamic statements on a one-time ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-schema-from-file-name.html
Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies within the schema directory. For this reason, it does not work with partitions or tables defined using their own ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-table-from-file-name.html
Given a file path name, returns the path component that represents the table name. This function is useful when extracting file I/O information from the Performance Schema that includes file path names. It provides a convenient way to display table ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-bytes.html
Note format_bytes() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_BYTES() function instead. See Section 14.21, “Performance Schema Functions” Given a byte ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-time.html
Note format_time() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.21, “Performance Schema Functions” Given a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. If the argument is not a valid consumer name, an error occurs. This function accounts for the consumer hierarchy, so a consumer ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-account.html
Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. The value should match the THREAD_ID column from some ...