Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
For example, the differences in maximum index key length make it risky to use utf8mb3 on the source and utf8mb4 on the replica. This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
Examples: utf8mb4_unicode_520_ci is based on UCA 5.2.0 weight keys (http://www.unicode.org/Public/UCA/5.2.0/allkeys.txt), utf8mb4_0900_ai_ci is based on UCA 9.0.0 weight keys (http://www.unicode.org/Public/UCA/9.0.0/allkeys.txt). This section ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. Tablespace keys are decrypted at the donor before transport and re-encrypted at the ...An error is reported if an encrypted connection is not available or the REQUIRE NO SSL clause is used in the CLONE INSTANCE ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_ssl_cert Command-Line Format --clone-ssl-cert=file_name System Variable clone_ssl_cert Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value empty string Specifies the path to the public key certificate. clone_ssl_key ... This section describes the system variables that control operation of the clone ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
HANDLER statement had not been present, MySQL would have taken the default action (EXIT) after the second INSERT failed due to the PRIMARY KEY constraint, and SELECT @x would have returned 2. statement handler_action: { CONTINUE | EXIT | UNDO } ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
For a 500,000-row table with a key value length of three bytes (the size of MEDIUMINT), the formula indicates log(500,000)/log(1024/3*2/(3+4)) + 1 = 4 seeks. To avoid this, increase the key cache size as the data grows. For MyISAM tables, the key ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
Also, the physical page size of the compressed table (KEY_BLOCK_SIZE) must be equal to FILE_BLOCK_SIZE/1024. For example, if innodb_page_size=16KB and FILE_BLOCK_SIZE=8K, the KEY_BLOCK_SIZE of the table must be 8. To determine a valid KEY_BLOCK_SIZE ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
Group Replication automatically configures the settings for the clone SSL options (clone_ssl_ca, clone_ssl_cert, and clone_ssl_key) to match your settings for the corresponding Group Replication distributed recovery options ... When a joining member ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
If the replication user for distributed recovery uses the caching SHA-2 authentication plugin, and you are not using SSL for distributed recovery connections, RSA key-pairs are used for password exchange. You can either copy the public key of the ...