新的HeatWave Advisor根据机器学习模型、数据分析和 HeatWave 查询历史提供 字符串列编码和数据放置键建议。实施 HeatWave Advisor 建议可以提高查询性能并减少 HeatWave 节点所需的内存量。

HeatWave Advisor 还提供查询洞察功能，该功能提供 成功执行的查询的运行时间、查询的运行时间估计、 EXPLAIN使用 取消 的Ctrl+C查询以及由于内存不足错误而失败的查询。运行时数据对于查询优化、故障排除以及估算运行特定查询或工作负载的成本很有用。

HeatWave Advisor 作为名为 的存储过程实现 heatwave_advisor，它驻留在 MySQL sys模式中。Running Advisor 涉及为带有可选参数的存储过程发出CALL语句。

CALL sys.heatwave_advisor (options);

有关 HeatWave Advisor 的更多信息，请参阅 使用 Advisor 优化工作负载。

新的HeatWave Auto Parallel Load实用程序可自动执行准备表并将其加载到 HeatWave 中的过程，并使用优化数量的并行加载线程加载数据。

HeatWave Auto Parallel Load 实用程序作为名为 的存储过程实现heatwave_load，它驻留在 MySQLsys架构中。运行 Auto Parallel Load 涉及为存储过程发出一条 CALL语句，该语句将模式和选项列表作为参数。

CALL sys.heatwave_load (db_list,[options]);

For more information about the HeatWave Auto Parallel Load utility, see Loading Data Using Auto Parallel Load.

The HeatWave query scheduling algorithm was improved. The revised algorithm prioritizes queries based on estimated cost and wait time in the queue, which enables dynamic, workload-aware query prioritization. Previously, queries were prioritized using a static cost-based prioritization model.

DATE_ADD() and DATE_SUB() functions now support precision INTERVAL values (DECIMAL, DOUBLE, and FLOAT). (Bug #32725985, Bug #32438123)

Support was added for multiple instances of COUNT(DISTINT) in a query. (Bug #32422984)

Query compilation and processing was improved to permit combining aggregate operators into a single task in the physical query plan, which avoids fully materializing intermediate result sets. This enhancement reduces memory allocation and deallocation operations, memory usage, and execution time for affected queries.

The cost model that estimates HeatWave query runtimes can now use statistics from previously executed queries, which improves the accuracy of query runtime estimates.

HeatWave 现在支持 CREATE TABLE ... SELECT将 SELECT查询卸载到 HeatWave 并在 MySQL 数据库服务实例上创建表的语句。在语句部分是长时间运行的复杂查询的CREATE TABLE ... SELECT情况下， 此功能可提高 性能。SELECT有关详细信息，请参阅 CREATE TABLE ... SELECT 语句。

添加了对 正则表达式函数的支持，并改进了 REGEXP_REPLACE()函数 语法不匹配、表达式错误和输入参数错误的错误消息。 REGEXP_SUBSTR()REGEXP()