Search Results
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 MySQL HeatWave now supports the ABS(), POWER(), and SIGN() mathematical functions. (WL #15246) MySQL 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 MySQL HeatWave to provide a holistic cost model across MySQL and MySQL HeatWave, create better query plans based on statistics used in MySQL Autopilot, reduce compilation time, eliminate the need ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and ...
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 MySQL HeatWave to optimize query execution time or memory usage and reduce the likelihood of queries running out of memory without user ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML has enhanced recommendation systems that can now recommend new users who are similar to a specific user and new items that are similar to other ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
(WL #15817) MySQL HeatWave MySQL HeatWave includes improvements to query optimization that lead to better performance for low latency queries in MySQL HeatWave and MySQL HeatWave Lakehouse. (WL #16048) MySQL HeatWave now supports the following JSON ... MySQL HeatWave AutoML MySQL HeatWave Autopilot MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML has increased the maximum model size from ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-0.html
This update allows for more detailed insights into model training, enabling better optimization and management of machine learning workflows. MySQL HeatWave can now check memory usage and release resources based on severity levels, ensuring optimal ... Note MySQL HeatWave User Guide has been restructured and improved to provide better visibility of high-level ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
This enhancement leverages statistics feedback to optimize query plans, particularly for queries with multiple joins and high MySQL costs. By injecting actual cardinalities from previous query executions into subsequent optimizations, MySQL HeatWave ... These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
Estimating Cluster Memory Size with MySQL HeatWave Autopilot 4.1.1 Estimating Cluster Memory Size with MySQL HeatWave Autopilot This topic describes how to estimate the optimal MySQL HeatWave Cluster size for your data. If you have not loaded data ...A cluster size estimate is generated using MySQL HeatWave Autopilot machine learning ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hwaml-create-model.html
Create a MySQL HeatWave AutoML model 13.2 Create a MySQL HeatWave AutoML model Use the MySQL HeatWave Console to create a new MySQL HeatWave AutoML model. Create a MySQL HeatWave AutoML model includes an advanced option to choose one or more ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Also notice that for prepared statements, if the stream length is not specified when using 'PreparedStatement.set*Stream()', the driver would not be able to determine the optimum number of parameters per batch and might return an error saying that ... callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is set to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
The optimal size for the connection pool depends on anticipated load and average database transaction time. In practice, the optimal connection pool size can be smaller than you might expect. Connection pooling is a technique of creating and ...