Search Results
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
For example, to set a key cache named hot_cache to a size of 10MB, use either of these statements: mysql> SET GLOBAL hot_cache.key_buffer_size = 10*1024*1024; mysql> SET @@GLOBAL.hot_cache.key_buffer_size = 10*1024*1024; To retrieve the cache size, ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Example mysql> CALL sys.execute_prepared_stmt('SELECT COUNT(*) FROM mysql.user'); +----------+ | COUNT(*) | +----------+ | 15 | +----------+ . Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-schema-from-file-name.html
Example mysql> SELECT sys.extract_schema_from_file_name('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------------------------+ | ... Given a file path name, returns the path component that represents ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-table-from-file-name.html
Example mysql> SELECT sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd'); +--------------------------------------------------------------------------+ | sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd') | ... Given a file path name, returns the path component that represents the table ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-bytes.html
Example mysql> SELECT sys.format_bytes(512), sys.format_bytes(18446644073709551615); +-----------------------+----------------------------------------+ | sys.format_bytes(512) | sys.format_bytes(18446644073709551615) | ... Note format_bytes() is ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-path.html
Example mysql> SELECT sys.format_path('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------+ | sys.format_path('/usr/local/mysql/data/world/City.ibd') | ... Given a path name, returns the modified path ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-time.html
Example mysql> SELECT sys.format_time(3501), sys.format_time(188732396662000); +-----------------------+----------------------------------+ | sys.format_time(3501) | sys.format_time(188732396662000) | ... Note format_time() is deprecated, and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-account-enabled.html
Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); +------------------------------------------------+ | sys.ps_is_account_enabled('localhost', 'root') | +------------------------------------------------+ | YES | ... Returns YES or ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-consumer-enabled.html
Example mysql> SELECT sys.ps_is_consumer_enabled('thread_instrumentation'); +------------------------------------------------------+ | sys.ps_is_consumer_enabled('thread_instrumentation') | +------------------------------------------------------+ | ... Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-account.html
Example mysql> SELECT sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())); +----------------------------------------------------------+ | sys.ps_thread_account(sys.ps_thread_id(CONNECTION_ID())) | ... Given a Performance Schema thread ID, ...