PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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. 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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/create-table-foreign-keys.html
If an operation violates more than one constraint, the two implementations can report different constraints while both correctly reject the operation. If the CONSTRAINT symbol clause is not defined, or a symbol is not included following the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-system-variables.html
The connection is used for both remote cloning operations and state transfer from the donor's binary log. It should be set to OFF both dynamically and in the configuration files. To use this function, both the donor and the joining member must be ...
https://dev.mysql.com/doc/refman/9.7/en/join.html
A table reference (when it refers to a partitioned table) may contain a PARTITION clause, including a list of comma-separated partitions, subpartitions, or both. INNER JOIN and , (comma) are semantically equivalent in the absence of a join ... MySQL ...