PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/charset-collation-compatibility.html
Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character set: mysql> SELECT _latin1 'x' COLLATE latin2_bin; ERROR 1253 (42000): COLLATION 'latin2_bin' is not valid for ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/clone-plugin-concurrent-ddl.html
Prior to MySQL 8.0.27, DDL operations on the donor and recipient MySQL Server instances, including TRUNCATE TABLE, are not permitted during a cloning operation. A workaround is to use dedicated donor instances, which can accommodate DDL operations ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'clone'; +------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +------------------------+---------------+ | clone | ACTIVE ... This section describes how to install and configure the clone ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone within a series such as MySQL 8.0.37 and MySQL 8.0.42.
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
The user you select to perform the cloning operation can be any MySQL user with the BACKUP_ADMIN privilege on *.*. The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. mysql> GRANT BACKUP_ADMIN ON *.* TO ...
https://dev.mysql.com/doc/refman/8.0/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.0/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 ...