Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-unload.html
Unload Advisor recommends tables to unload, reducing MySQL HeatWave memory usage. The recommendations are based upon when the tables were last queried. Run Unload Advisor For Advisor to recommend tables to unload, the tables must be loaded in MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using Incremental Load”. This adds an include list to exactly specify the tables and columns to load for a set ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. To learn how to download the sample database, see AirportDB Analytics Quickstart. Setting Secondary Engine Definition By default, SELECT queries are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
We recommend not sharing stream OCIDs across DB Systems, and limiting the usage of each stream OCID for only event-based incremental load. As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental load. Once an event ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads tables and partitions based on usage. Loading data using Auto Parallel Load: loads one or more schemas at a time and facilitates loading by ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries.html
Note For queries that monitor MySQL HeatWave node status, memory usage, data loading, change propagation, and queries, see Section 5.10, “MySQL HeatWave Monitoring”. This section provides Information Schema and Performance Schema queries that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-option-tracker.html
The Option Tracker component provides usage information about different features and components of MySQL HeatWave. As of MySQL 9.2.1, the boolean flag used has been replaced with an integer flag usedCounter in the option_tracker_usage_get() and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
The rpd_nodes read-only table provides information about MySQL HeatWave nodes. The table may not show the current status for a new node or newly configured node immediately. The rpd_nodes table is updated after the node has successfully joined the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
Solution A: Your query contains an unsupported predicate, function, operator, or has encountered some other limitation. Solution B: Query execution time is less than the query cost threshold. MySQL HeatWave is designed for fast execution of large ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Unload Advisor Recommends tables to unload, reducing MySQL HeatWave memory usage. Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining data placement keys to ...