New MySQL HeatWave capabilities released in 8.0.32

MySQL HeatWave has added new capabilities on both OCI and AWS platforms. Here is the list of features introduced in 8.0.32.

 

Query Performance

Reduced HeatWave query compilation time for queries with large number of joins

With the introduction of the multi-engine hypergraph-based optimizer with HeatWave in 8.0.31, we can explore a large search space for join order optimization. HeatWave can support more complex queries with more than 25 joins. However, with more complex queries, query compilation time can get longer. Query compilation time is constant regardless of the data size and query processing time. As a result, the query compilation time can become a larger percentage of the total runtime.

With this improvement, we reduced the compilation time by employing dynamic programing techniques, improving overall query runtime for queries with short execution time. Using a real-world workload with complex queries, query compilation time is reduced by 15x to 20x.

 

MD5(), SHA1(), SHA(), SHA2(), RANDOM_BYTES() encryption functions support

Queries with MD5(), SHA1(), SHA(), SHA2(), RANDOM_BYTES() functions are now accelerated in HeatWave.

 

CRC32(), LOG10(), LOG2(), RAND() arithmetic functions support

Queries with CRC32(), LOG10(), LOG2(), RAND() functions are now accelerated in HeatWave.

 

COMPRESS(), UNCOMPRESS(), UNCOMPRESS_LENGTH() compression functions support

Queries with COMPRESS(), UNCOMPRESS(), UNCOMPRESS_LENGTH() functions are now accelerated in HeatWave.

 

HeatWave AutoML

Progress tracking for ML queries

Machine learning training is the most time-consuming operation which can range from minutes to hours. Users do not get any progress of the operation during training. With this feature, user can now get feedback on the progress of the training operation. While running a machine learning training query (ML_TRAIN), user can now track the query progress. The progress tracker will indicate if the status of training is “In Progress”, “Completed”, “Error” or ““Aborted”.

 

Addition Resources