Search Results
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 ... As of MySQL 9.1.0, Auto Parallel Load uses Autopilot to collect statistics about frequently used InnoDB ...
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 ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
(WL #15817) HeatWave MySQL HeatWave MySQL includes improvements to query optimization that lead to better performance for low latency queries in HeatWave MySQL and HeatWave Lakehouse. (WL #16048) HeatWave MySQL now supports the following JSON ...