Search Results
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the source. It also updates the contents of the replication metadata repositories (see Section 19.2.4, “Relay Log ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-compatibility.html
Each character set has one or more collations, but each collation is associated with one and only one character set. Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-installation.html
This section describes how to install and configure the clone plugin. For remote cloning operations, the clone plugin must be installed on the donor and recipient MySQL server instances. For general information about installing or uninstalling ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-local.html
The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. mysql> GRANT BACKUP_ADMIN ON *.* TO 'clone_user'; where clone_user is the MySQL user that performs the cloning operation. The user you select to perform the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-stop.html
If necessary, you can stop a cloning operation with a KILL QUERY processlist_id statement. On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status ...
https://dev.mysql.com/doc/refman/8.4/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...