Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Because the adaptive hash index may not be useful for all workloads, conduct benchmarks with it both enabled and disabled, using realistic workloads. The innodb_flush_method options for Unix-like systems include: fsync or 0: InnoDB uses the fsync() ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
Use this address to permit both IPv4 and IPv6 connections on all server interfaces. If you disable the default storage engine at server startup, you must set the default engine for both permanent and TEMPORARY tables to a different engine, or else ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
In all cases where the source and target tables do not have identical definitions, the database and table names must be the same on both the source and the replica. (This is true even if both tables have the same number of columns.) Columns common ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1705; Symbol: ER_STMT_CACHE_FULL; SQLSTATE: HY000 Message: Multi-row statements required more than 'max_binlog_stmt_cache_size' bytes of storage; increase this mysqld variable and try again Error number: 1706; Symbol: ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/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.4/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/8.4/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.4/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.4/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/8.4/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 ...