Changes in MySQL HeatWave 8.1.0 (2023-07-18, General Availability)

• 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 items. See Generate Recommendations. (WL #15674)

• Improvements to MySQL HeatWave AutoML models, the model catalog, and ML_MODEL_IMPORT now fully support ONNX and MySQL HeatWave AutoML model import. (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 intervention. (WL #15529)

• It is now possible to track the memory used by change propagation and the number of transactions committed to MySQL InnoDB that are waiting to be propagated to MySQL HeatWave. (WL #15326, WL #15688)

• MySQL HeatWave now accelerates queries with INTERSECT and EXCEPT clauses. With this support, MySQL HeatWave can now offload and accelerate all 97 TPC-DS queries. (WL #15362)

• MySQL HeatWave now supports the following temporal functions:

  • GET_FORMAT()

  • MAKETIME()

  • PERIOD_ADD()

  • PERIOD_DIFF()

  • SEC_TO_TIME()

  • SUBTIME()

  • SYSDATE()

  • TIMEDIFF()

  (WL #14958)