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/stop-slave.html
From MySQL 8.0.22, STOP SLAVE is deprecated and the alias STOP REPLICA should be used instead. STOP {SLAVE | REPLICA} [thread_types] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.0/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.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 | | ...