Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/en/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy mode. Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be ...
https://dev.mysql.com/doc/refman/8.4/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. MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; SELECT x FROM T WHERE x = x; SELECT DISTINCT x FROM T; However, with multiple operands, there can be ambiguity. In ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-implementations.html
Complex collations for 8-bit character sets This kind of collation is implemented using functions in a C source file that define how to order characters, as described in Section 12.13, “Adding a Character Set”. MySQL implements several types of ...