Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
The following table provides an overview of encoding type characteristics: Table 5.15 Column Encoding Type Characteristics Encoding Type Expression, Filter, Function, and Operator Support Best Suited To Space Required On Variable-length (VARLEN) ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
As the DB system high availability feature uses MySQL Group Replication, for which each table must have a primary key. If you try to create a table without a primary key in a high availability DB system, it will fail. If you are migrating tables to ... Prerequisites 12.2 Prerequisites Here are some prerequisites for creating a high availability DB ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Then, the MySQL HeatWave query processing engine (RAPID) is set as the secondary engine for the table, using ALTER TABLE statement. Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
The undo tablespace was either selected by the purge thread implicitly or was made inactive by an ALTER UNDO TABLESPACE ... It is ready to be dropped or made active again by an ALTER UNDO TABLESPACE ... The INNODB_TABLESPACES table provides ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
This statement is mapped to an ALTER TABLE statement to drop the index. They have the same meaning as for the ALTER TABLE statement. For more information, see Section 15.1.9, “ALTER TABLE Statement” MySQL NDB Cluster supports online operations ...algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
(WL #16513) MySQL HeatWave Lakehouse now supports an optional clause for the ALTER TABLE SECONDARY_LOAD statement, enabling you to control whether MySQL HeatWave Guided Load is used or not. This update introduces additional data preparation ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that pertain only to specific operations, such as table checking or repairing.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-blobs.html
The part and inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see NDB_COLUMN Options); this can also be done in NDB API applications (see Column::setPartSize() and ...For ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The string data types are CHAR, VARCHAR, BINARY, ...
https://dev.mysql.com/doc/refman/8.4/en/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...If ...