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-setup-enable-background-threads.html
Produces a result set indicating how many background threads were enabled. Example mysql> CALL sys.ps_setup_enable_background_threads(); +-------------------------------+ | summary | +-------------------------------+ | Enabled 24 background threads ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-consumer.html
Enables Performance Schema consumers with names that contain the argument. Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern match. Example Enable all ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-instrument.html
Enables Performance Schema instruments with names that contain the argument. Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Example ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-thread.html
Given a connection ID, enables Performance Schema instrumentation for the thread. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Example Enable a ...
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-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
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-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...