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/pluggable-storage-common-layer.html
Physical Storage: This involves everything from the overall page size for tables and indexes as well as the format used for storing data to physical disk. A MySQL pluggable storage engine is the component in the MySQL database server that is ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
The storage required for remaining digits is given by the following table. This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
All group members receive the current source list as recorded in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables. In MySQL 8.0.27 and later, asynchronous connection ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
Beginning with MySQL 8.0.22, you can use the asynchronous connection failover mechanism to automatically establish an asynchronous (source to replica) replication connection to a new source after the existing connection from a replica to its source ...The asynchronous connection failover mechanism can be used to keep a replica synchronized with multiple MySQL servers or groups of servers that share ...
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a repeatable test case that demonstrates the bug, please enter it into ...We need to obtain as much information as possible from you to be able to track down the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql schema are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
Table 14.28 Positional Synchronization Functions Name Description Deprecated MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position Yes SOURCE_POS_WAIT() Block until the replica has read and applied ... 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-functions.html
The functions described in the following sections are used with MySQL Replication. GTID_SUBTRACT() Return all GTIDs in set that are not in subset. MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.0), and that you have enabled a replication user and ...Use the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...