PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-background-threads.html
Example mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background threads | +--------------------------------+ . Produces a result set indicating ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-consumer.html
Example Disable all statement consumers: mysql> CALL sys.ps_setup_disable_consumer('statement'); +----------------------+ | summary | +----------------------+ | Disabled 4 consumers | +----------------------+ . Disables Performance Schema consumers ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-background-threads.html
Example mysql> CALL sys.ps_setup_enable_background_threads(); +-------------------------------+ | summary | +-------------------------------+ | Enabled 24 background threads | +-------------------------------+ . Produces a result set indicating how ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-consumer.html
Example Enable all statement consumers: mysql> CALL sys.ps_setup_enable_consumer('statement'); +---------------------+ | summary | +---------------------+ | Enabled 4 consumers | +---------------------+ . Enables Performance Schema consumers with ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-reset-to-default.html
Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure execution. row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled-consumers.html
Example mysql> CALL sys.ps_setup_show_disabled_consumers(); +----------------------------------+ | disabled_consumers | +----------------------------------+ | events_stages_current | | events_stages_history | | events_stages_history_long | | ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled-consumers.html
Example mysql> CALL sys.ps_setup_show_enabled_consumers(); +-----------------------------+ | enabled_consumers | +-----------------------------+ | events_statements_current | | events_statements_history | | events_transactions_current | | ...
https://dev.mysql.com/doc/refman/8.0/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, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html
+-----------------------------------------------------------------+ | sql_text | +-----------------------------------------------------------------+ | select hibeventhe0_.id as id1382_, hibeventhe0_.createdTime ... Traces all Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result ...