Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Indexes can improve the query performance of SELECT statements, but index management can increase the overhead of DML operations, INSERT, UPDATE, and DELETE. Autopilot Indexing obtains workloads from the statement digest history stored in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Before You Begin Ensure ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
The bulk load operation compares the records from the input CSV files and the existing table, and then inserts the data into the existing table so that it is sorted correctly. MySQL includes a bulk load extension to the LOAD DATA statement that is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
DML operations, INSERT, UPDATE, and DELETE, on the DB System do not wait for changes to be propagated to the MySQL HeatWave Cluster; that is, DML operations on the DB System are not delayed by MySQL HeatWave change propagation. After tables are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. A temporary table is visible only within the current session, and is dropped automatically when you close the session. Once created, you can use a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
Avoid dictionary encoding for columns with a high number of inserts and updates. This topic describes how to prepare your data for loading into MySQL HeatWave. Prepare Data Before loading data, ensure that you meet the following requirements: The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following options for the CREATE TABLE statement: AUTOEXTEND_SIZE AVG_ROW_LENGTH CHECKSUM ...