PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-consumer-enabled.html
(Prior to MySQL 8.0.18, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled.
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-instrument-default-enabled.html
Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); +-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | ... Returns YES or ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-thread-instrumented.html
Example mysql> SELECT sys.ps_is_thread_instrumented(43); +-----------------------------------+ | sys.ps_is_thread_instrumented(43) | +-----------------------------------+ | UNKNOWN | +-----------------------------------+ mysql> SELECT ... Returns ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-instrument.html
Example Disable a specific instrument: mysql> CALL sys.ps_setup_disable_instrument('wait/lock/metadata/sql/mdl'); +-----------------------+ | summary | +-----------------------+ | Disabled 1 instrument | +-----------------------+ Disable all mutex ... Disables Performance Schema instruments with names that contain the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-thread.html
Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | Disabled 1 thread | +-------------------+ Disable the current connection: mysql> CALL ... Given a connection ID, disables Performance Schema instrumentation for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-instrument.html
Example Enable a specific instrument: mysql> CALL sys.ps_setup_enable_instrument('wait/lock/metadata/sql/mdl'); +----------------------+ | summary | +----------------------+ | Enabled 1 instrument | +----------------------+ Enable all mutex ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-thread.html
Example Enable a specific connection by its connection ID: mysql> CALL sys.ps_setup_enable_thread(225); +------------------+ | summary | +------------------+ | Enabled 1 thread | +------------------+ Enable the current connection: mysql> CALL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). Parameters in_timeout INT: How many seconds to wait to obtain ...This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-statement-avg-latency-histogram.html
This procedure can be used to display a very high-level picture of the latency distribution of statements running within this MySQL instance. Displays a textual histogram graph of the average latency values across all normalized statements tracked ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If sys_get_config() returns the default value and that value is ...