PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/user-variables.html
The order of evaluation for expressions involving user variables is undefined. HAVING, GROUP BY, and ORDER BY, when referring to a variable that is assigned a value in the select expression list do not work as expected because the expression is ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-choosing-id.html
To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
MySQL uses the stored key distribution to decide the order in which tables should be joined for joins on something other than a constant. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and spatial data types (see Section 13.4.1, “Spatial Data Types”). The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL 8.0.34). Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data.
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
For example, the Transaction_payload_event is decompressed by an applier thread in order to apply the events it contains on the recipient. Beginning with MySQL 8.0.20, you can enable binary log transaction compression on a MySQL server instance.
https://dev.mysql.com/doc/refman/8.0/en/blob.html
A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. They ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
When assigning indexes for multiple partitions to a key cache, the partitions need not be contiguous, and you need not list their names in any particular order. | tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name ...