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/replication-gtids-functions.html
The procedure used is to back up server2 using mysqldump, then to restore this backup on server1. This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-background-threads.html
Produces a result set indicating how many background threads were disabled. Example mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-consumer.html
Disables 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 Disable ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-instrument.html
Disables 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-disable-thread.html
Given a connection ID, disables 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 Disable a ...
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 | | ...