Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
To unload a table manually, specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement: mysql> ALTER TABLE tbl_name SECONDARY_UNLOAD; The following example unloads the data_table_1 table. mysql> ALTER TABLE data_table_1 SECONDARY_UNLOAD; Data ...Unload Tables Unloading a table from MySQL HeatWave may be necessary to replace an existing table, to reload a table, to free up memory, or simply to remove a table that is no longer ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-bulk-ingest-limitations.html
If needed, use ALTER TABLE to change the table's row format after running LOAD DATA FROM S3 with ALGORITHM=BULK. Bulk Ingest Limitations 7.2.2.3 Bulk Ingest Limitations The following are some limitations to the Bulk Ingest Feature of MySQL HeatWave ...If needed, set the secondary engine after running LOAD DATA FROM S3 with ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...For ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...Note ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
ALTER TABLESPACE cannot be used to configure the AUTOEXTEND_SIZE of a file-per-table tablespace. By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following ...For information about extent size, see Section 17.11.2, “File Space ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
In MySQL 8.4, it also waits for the completion of any ongoing DDL statements such as ALTER TABLE. You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. The following function ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
The ordering constraint also applies to the use of ALTER TABLE to reorder table columns. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. An expression ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
| | | +--------------+-------------------+---------------------------------------------+ mysql> ALTER TABLE airline_info SECONDARY_LOAD; Query OK, 0 rows affected (3.9098 sec) mysql> SELECT TABLE_SCHEMA, TABLE_NAME, CREATE_OPTIONS FROM ... To ...If ...