Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
See Automatic Loading and Unloading of DB System Tables and Partitions. You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to create ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
Features like Auto Zonemap and MySQL table partitions also impact the base relation data scanned by a query. MySQL HeatWave tracks the amount of base relation data scanned by all queries collectively and by individual queries. Base relation data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. Then, the MySQL HeatWave query processing engine ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to run a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
MySQL HeatWave on OCI does not support LOAD DATA with ALGORITHM=BULK. MySQL HeatWave on AWS does support LOAD DATA with ALGORITHM=BULK, but does not support the INFILE and URL clauses. For versions earlier than MySQL 9.4.0, tables must have a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Before You Begin Complete the steps to load data using Auto Parallel Load or manually. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-tables.html
mysql> CALL sys.HEATWAVE_RELOAD([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ["only_user_loaded_tables",{true|false}] ["output",{"normal"|"silent"}] } } Use key-value pairs in JSON format to specify options.
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
Includes prepart data, which can be queried to determine if a JOIN or GROUP BY query used data placement partitions. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format.