Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview-data-storage.html
The source data is read from Object Storage, transformed to the memory optimized HeatWave format, stored in the HeatWave persistence storage layer in Object Storage, and then loaded to HeatWave cluster memory. This memory optimized internal version ...This data is not directly accessed by end-users of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-best-practice.html
Tip The Auto Parallel Load utility automatically optimizes the number of parallel read threads for each table. For users of HeatWave on AWS, the number of parallel read threads is also optimized when loading data from the HeatWave Console. Instead ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
To load data manually, follow these steps: Optionally, applying string column encoding and data placement workload optimizations. The use of partition information can allow data-skipping and accelerate query processing. HeatWave Guided Load uses ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
This HeatWave Autopilot enabled method loads one or more schemas at a time and facilitates loading by automating manual steps and optimizing the number of parallel load threads for a faster load. This GUI-based and HeatWave Autopilot enabled method ...This method loads one table at a time and involves executing multiple statements for each ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl.html
Oracle AutoML automates this workflow, providing you with an optimal model given a time budget. The HeatWave AutoML ML_TRAIN routine leverages Oracle AutoML technology to automate the process of training a machine learning model. Oracle AutoML ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
optimization_metric: The scoring metric to optimize for when training a machine learning model. mysql> CALL sys.ML_TRAIN('ml_data.iris_train', 'class', JSON_OBJECT('task','classification', 'exclude_model_list', JSON_ARRAY('LogisticRegression', ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26-u1.html
HeatWave Network Layer HeatWave Data Management Layer Functionality Added or Changed HeatWave Network Layer HeatWave network layer optimizations have improved scalability and network performance. For optimal performance, window functions in ...(WL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30-u1.html
With this optimization, decompression is avoided entirely for data that is filtered out. Functionality Added or Changed HeatWave now supports the ABS(), POWER(), and SIGN() mathematical functions. (WL #15246) HeatWave now supports the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
(WL #14713) A new MySQL optimizer is introduced for HeatWave to provide a holistic cost model across MySQL and HeatWave, create better query plans based on statistics used in MySQL Autopilot, reduce compilation time, eliminate the need of query ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-1-0.html
(WL #15383, WL #15559) Functionality Added or Changed Memory-aware query optimization now automatically adjusts HeatWave to optimize query execution time or memory usage and reduce the likelihood of queries running out of memory without user ...