Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated; you should expect them to be ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/8.4/en/cleartext-pluggable-authentication.html
Table 8.17 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . In MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
User-created data (schemas, tables, tablespaces) and binary logs on the recipient are removed before data is cloned to the recipient data directory. [Warning] [MY-013453] [InnoDB] Clone removing all user data for provisioning: Finished If a failure ... This section describes failure handing at different stages of a cloning ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). This section describes how to install and configure the clone plugin. For ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
MyISAM and CSV tables stored in any schema including the sys schema are cloned as empty tables. Local cloning operations do not support cloning of general tablespaces that were created with an absolute path. A cloned tablespace file with the same ...
https://dev.mysql.com/doc/refman/8.4/en/communication-errors.html
The host cache, which is accessible using the Performance Schema host_cache table. See Section 7.1.12.3, “DNS Lookups and the Host Cache”, and Section 29.12.22.3, “The host_cache Table”. If connection problems occur such as communication ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/compilation-problems.html
Versions of bison older than 1.75 may report this error: sql_yacc.yy:#####: fatal error: maximum table size (32767) exceeded The maximum table size is not actually exceeded; the error is caused by bugs in older versions of bison. If you do ...