MySQL HeatWave Release Notes
These release notes were created with the assistance of MySQL HeatWave GenAI.
The MySQL HeatWave GenAI Javascript API now supports batch processing,
making it possible to perform multiple operations in a single
call. This update introduces batch processing functionality to
the LLM class and API
convenience methods (see
Convenience Methods), allowing for
more efficient embedding, text-based content generation, and
Retrieval Augmented Generation (RAG).
For more information, see JavaScript GenAI API. (WL #16514)
Lakehouse Autopilot can now automatically detect the dialect
for CSV files, which lets you load the CSV files without knowing
the exact values of the dialect delimiter
parameters in advance. This feature automates the detection of
record delimiters, field delimiters, and composite record
delimiters with field delimiters as prefixes.
For more information, see Lakehouse External Table Syntax. (WL #16546)
Bulk load, which is used for ingesting data into MySQL Server, now supports the following:
Secondary indexes, which enable faster data loading and
improved performance. This feature allows for the creation
of secondary indexes during the bulk load process, reducing
the need for additional ALTER TABLE
statements.
Faster and more efficient bulk loading of CSV files. This enhancement allows for parallelized CSV parsing, reducing the need for redundant reads and improving overall performance.
For more information, see Bulk Ingest Data. (WL #16266, WL #15986)
MySQL HeatWave now supports JSON tables, enabling you to extract data from JSON documents and return it as relational tables.
For more information, see JSON Functions. (WL #16450)
MySQL HeatWave now supports offloading the INSERT INTO
SELECT queries to the secondary engine, even when the
table being inserted into has triggers defined on it. This
enables faster query execution and improved performance for
workloads that involve inserting data into tables with triggers.
For more information, see INSERT ... SELECT Statements. (WL #16235)
MySQL HeatWave now reloads data from Storage Layer after a planned or unplanned restart of Standalone DB system, thus reducing the recovery time and improving overall system reliability.
For more information, see About MySQL HeatWave. (WL #14953)