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/innodb-compression-internals.html
The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of compression. One technique MySQL uses is to maintain some system information in the B-tree node in uncompressed form, thus ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
For those cases where there are long rows, the use of compression might result in long column values being stored “off-page”, as discussed in DYNAMIC Row Format. In addition to user data, the page format includes some internal system data that ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
Tables created in file-per-table tablespaces support features associated with DYNAMIC and COMPRESSED row formats, which are not supported by the system tablespace. A file-per-table tablespace contains data and indexes for a single InnoDB table, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html
The index key prefix length limit is 3072 bytes for InnoDB tables that use DYNAMIC or COMPRESSED row format. The index key prefix length limit is 767 bytes for InnoDB tables that use the REDUNDANT or COMPACT row format. This section describes ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
For information about using the DATA DIRECTORY clause, see Section 17.6.1.2, “Creating Tables Externally”. If a ROW_FORMAT option is not defined explicitly in the table definition or ROW_FORMAT=DEFAULT is used, the innodb_default_row_format ...
https://dev.mysql.com/doc/refman/8.0/en/installing.html
If you plan to upgrade an existing version of MySQL to a newer version rather than install MySQL for the first time, see Chapter 3, Upgrading MySQL, for information about upgrade procedures and about issues that you should consider before upgrading.
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
JSON_PRETTY() prints out a JSON value in a format that is easy to read. Formatting of the output from this function adheres to the following rules: Each array element or object member appears on a separate line, indented by one additional level as ... This section documents utility functions that act on JSON values, or strings that can be parsed as JSON ...
https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html
JSON_SCHEMA_VALID() returns true if the document validates against the schema, and false if it does not; JSON_SCHEMA_VALIDATION_REPORT() provides a report in JSON format on the validation. In MySQL 8.0.19 and later, you can obtain precise ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_okv, Section 8.4.4.13, “Supported Keyring Key ...