Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
Execution occurs if query processing using the secondary engine advances past the preparation and optimization stages. Data is tracked in megabytes and is a cumulative total of data scanned since the HeatWave Cluster was last started. The counter is ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
Most HeatWave variable settings are managed by OCI and cannot be modified directly. bulk_loader.data_memory_size Command-Line Format --bulk_loader.data_memory_size=# System Variable bulk_loader.data_memory_size Scope Global Dynamic Yes SET_VAR Hint ...
https://dev.mysql.com/doc/heatwave/en/index.html
It covers how to load data, run queries, optimize analytics workloads, and use HeatWave machine learning capabilities. For information about creating and managing a HeatWave Cluster on Oracle Cloud Infrastructure (OCI), see HeatWave on OCI Service ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Autopilot Indexing can generate secondary index recommendations that optimize the overall workload performance. As of MySQL 9.0.0, HeatWave Autopilot Advisor includes Autopilot Indexing that can make secondary index suggestions to improve workload ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Runtime data can be used for query optimization, troubleshooting, or to estimate the cost of running a particular query or workload on HeatWave. Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-best-practice.html
Advisor analyzes the data and HeatWave query history to provide string column encoding and data placement key recommendations. Run Advisor again for updated recommendations when queries change, when data changes significantly, and after reloading ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-execution-auto-enc.html
In the following example, Auto Encoding is run in recommend mode, which analyzes column data, checks the amount of memory on the MySQL node, and provides encoding recommendations intended to reduce the amount of space required on HeatWave nodes and ... To enable Auto Encoding, specify the auto_enc option in recommend ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Specifying fewer combinations generates recommendations more quickly but recommendations may not be optimal. Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
As of MySQL 9.1.0, Auto Parallel Load uses Autopilot to collect statistics about frequently used InnoDB tables. If a manually loaded table might cause a memory conflict, Auto Unload unloads automatically loaded tables to free up memory. Auto ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dynamic-query-offload.html
As of MySQL 9.0.0, HeatWave MySQL uses dynamic query offload to choose the optimal execution engine for queries based on query and execution engine characteristics, which achieves improved performance. The overhead for more complex queries is also ... Before MySQL 9.0.0, HeatWave MySQL uses a query cost threshold to choose the execution engine for the ...