MySQL HeatWave Release Notes

2.8 Changes in MySQL HeatWave 9.2.1 (2025-02-20, General Availability)

Note

These release notes were created with the assistance of MySQL HeatWave GenAI.

MySQL HeatWave GenAI

  • Context search in MySQL HeatWave GenAI now lets you use your own embedding tables. This enhancement enables more flexible query enrichment for Large Language Models (LLMs). This update extends the search capabilities of the ML_RAG, ML_RAG_TABLE, and HEATWAVE_CHAT routines to include your own embedding tables.

    For more information, see Use Your Own Embeddings and Run MySQL HeatWave Chat. (WL #16537)

MySQL HeatWave

  • MySQL HeatWave now supports automatic recovery of loaded InnoDB tables from Storage Layer after a planned or unplanned restart of the primary DB system. This feature extends the existing functionality of automatic recovery from Storage Layer for Standalone DB systems to HA DB systems, thus reducing the recovery time, increasing the availability, and improving the overall system reliability. However, Lakehouse tables in HA DB systems still need to be recovered from Object Storage.

    For more information, see About MySQL HeatWave. (WL #16627)

  • MySQL HeatWave now supports automated zone map construction on non-primary key columns, improving RAPID query processing performance. This feature uses a workload-driven approach to select the most beneficial zone map columns based on query history, continuously adapting to the workload.

    For more information, see About MySQL HeatWave. (WL #15993)

  • The POOL_TYPE column in MySQL HeatWave Performance Schema tables no longer includes the RAPID_LOAD_POOL_ prefix. The possible values are now SNAPSHOT and TRANSACTIONAL.

    For more information, see The rpd_tables Table. (WL #16630)

  • For tracking the usage of various components, MySQL HeatWave Option tracking now supports a single, fast counter, usedCounter, instead of a boolean value, used. The counter indicates the number of times a component is used.

    For more information, see Option Tracker. (WL #16721, WL #16732)