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/charset-unicode-sets.html
Unicode Collation Algorithm (UCA) Versions Collation Pad Attributes Language-Specific Collations _general_ci Versus _unicode_ci Collations Character Collating Weights Miscellaneous Information Unicode Collation Algorithm (UCA) Versions MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
The remote cloning operation replaces the existing data dictionary on the joining member, but Group Replication checks and does not proceed if the joining member has additional transactions that are not present on the other group members, because ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
Such a table might be useful as a template for creating new MERGE tables with CREATE TABLE ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
unique_subquery This type replaces eq_ref for some IN subqueries of the following form: value IN (SELECT primary_key FROM single_table WHERE some_expr) unique_subquery is just an index lookup function that replaces the subquery completely for better ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
Compression Algorithms Some operating systems implement compression at the file system level. MySQL implements compression with the help of the well-known zlib library, which implements the LZ77 compression algorithm. This compression algorithm is ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns ...Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
ssl-session-data-continue-on-failed-reuse Command-Line Format --ssl-session-data-continue-on-failed-reuse Introduced 8.0.29 Type Boolean Default Value OFF Controls whether a new connection is started to replace an attempted connection that tried but ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are ...
https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html
More exactly, a variation of the nested-loop join algorithm is exploited. Recall the algorithm by which the nested-loop join executes a query (see Section 10.2.1.7, “Nested-Loop Join Algorithms”). The following discussion refers to the join ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it possible to use 3rd party encryption algorithms in place of the one provided by the InnoDB data-at-rest encryption feature? A.17.5. What are the encryption ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
The data-at-rest encryption feature supports the Advanced Encryption Standard (AES) block-based encryption algorithm. Tables residing in file-per-table tablespaces are rebuilt using the COPY algorithm. The INPLACE algorithm is used when altering the ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...