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/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. Table Repair Considerations REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
However, the replica notices the network outage only after receiving no data from the source for replica_net_timeout or slave_net_timeout seconds. If your outages are short, you may want to decrease the value of replica_net_timeout or ... It is safe ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
If the applier does not reach the stated position, the function waits until the timeout. Depending on the setting for the system variables, the function might therefore return some time after the specified position was reached. If a timeout value is ... The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-enable-gtids.html
The following procedure can be paused at any time and later resumed where it was, or reversed by jumping to the corresponding step of Section 19.1.4.3, “Disabling GTID Transactions Online”, the online procedure to disable GTIDs. If you use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. The statement can therefore potentially be left in the dump output when you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. For instructions to do this, see Section 9.5, “Point-in-Time (Incremental) Recovery”. If a privilege check against the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
Whenever the 50 most recent ER_BINLOG_UNSAFE_STATEMENT warnings have been generated more than 50 times in any 50-second period, warning suppression is enabled. When activated, this causes such warnings not to be written to the error log; instead, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
rpl_semi_sync_source_timeout or rpl_semi_sync_master_timeout A value in milliseconds that controls how long the source waits on a commit for acknowledgment from a replica before timing out and reverting to asynchronous replication. The replication ... When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous Replication”), system variables become available to control plugin ...