PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
The following table shows the suffixes used to indicate these characteristics. Table 12.1 Collation Suffix Meanings Suffix Meaning _ai Accent-insensitive _as Accent-sensitive _ci Case-insensitive _cs Case-sensitive _ks Kana-sensitive _bin Binary For ... MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
Before 8.0.37, the point release number also had to match, so cloning the likes of 8.0.36 to 8.0.42 or vice-versa is not permitted Prior to MySQL 8.0.27, DDL on the donor and recipient, including TRUNCATE TABLE, is not permitted during a cloning ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
Note A local cloning operation does not support cloning of user-created tables or tablespaces that reside outside of the data directory. Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File ...The ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-stop.html
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 table. If necessary, you can stop a cloning operation with a KILL QUERY processlist_id ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata. By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary ... The clone plugin, introduced in MySQL 8.0.17, permits cloning data locally or from a remote MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
For source/replica replication connections, the configured compression algorithms and compression level are available from multiple sources: The Performance Schema replication_connection_configuration table has COMPRESSION_ALGORITHMS and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS implements an INFORMATION_SCHEMA table that exposes more detailed monitoring information for failed connection attempts. For more information about this table, see Section 28.6.2, “The INFORMATION_SCHEMA ...