PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
Suppose that the server is started with --binlog-do-db=db1, and the following statements are executed: USE db1; UPDATE db1.table1, db2.table2 SET db1.table1.col1 = 10, db2.table2.col2 = 20; If you are using statement-based logging, the updates to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
Suppose that the replica is started with --replicate-do-db=db1, and the following statements are executed on the source: USE db1; UPDATE db1.table1, db2.table2 SET db1.table1.col1 = 10, db2.table2.col2 = 20; If you are using statement-based ... This ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
To use TLSv1.3, both the MySQL server and the client application must be compiled using OpenSSL 1.1.1 or higher. In particular, note that to use TLSv1.3, both the MySQL server and the client application must be compiled using OpenSSL 1.1.1 or higher. MySQL instance configuration Permitted TLS protocols can be configured on both the server side and client side to include only a subset of the supported TLS ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Because this feature benefits some workloads and not others, and the memory used for the hash index is reserved in the buffer pool, typically you should benchmark with this feature both enabled and disabled. buffer pool The memory area that holds ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
The connection is used for both remote cloning operations and state transfer from the donor's binary log. To ensure the new member's correct operation, take both of the following precautions: Before the server running the lower version joins the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Requirements Preparations for conflict resolution must be made on both the source and the replica. NDB$OLD() NDB$MAX() NDB$MAX_DELETE_WIN() NDB$MAX_INS() NDB$MAX_DEL_WIN_INS() NDB$EPOCH() NDB$EPOCH_TRANS() NDB$EPOCH2() NDB$EPOCH2_TRANS() NDB$OLD() ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--ignore-table=db_name.tbl_name Command-Line Format --ignore-table=db_name.tbl_name Type String Do not dump the given table, which must be specified using both the database and table names. The RELOAD or FLUSH_TABLES privilege is required with ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
Both the receiver thread and the applier thread must be stopped before issuing a CHANGE MASTER TO statement that employs MASTER_AUTO_POSITION = 1, GTID_ONLY = 1, or ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS. Both the replication SQL thread and the ...] ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
Both the receiver thread and the applier thread must be stopped before issuing a CHANGE REPLICATION SOURCE TO statement that employs SOURCE_AUTO_POSITION = 1, GTID_ONLY = 1, or ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS. Both the replication SQL thread ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The syntax of the FIELDS and LINES clauses is the same for both statements. LOCAL works only if the server and your client both have been configured to permit it. Field and Line Handling For both the LOAD DATA and SELECT ... Both clauses are ...The ...