MySQL HeatWave Release Notes
MySQL HeatWave now supports querying views. See Query Views. (WL #13568)
Bloom filter join optimizations were introduced. For MySQL HeatWave queries that join large and small relations, bloom filters reduce the amount of data processed by early filtering and the amount of memory used during query processing. (WL #14752)
The rpd_query_stats
table, which stores
MySQL HeatWave query history (compilation and execution statistics),
now stores data for the last 1000 executed queries. Previously,
data was stored for the last 200 queries.
The following columns were added to the
performance_schema.rpd_tables
table:
SIZE_BYTES
: The amount of data loaded per
table, in bytes.
QUERY_COUNT
: The number of queries that
referenced the table.
LAST_QUERIED
: The timestamp of the last
query that referenced the table.
LOAD_END_TIMESTAMP
: The load completion
timestamp for the table.
The following column was added to the
performance_schema.rpd_columns
table:
DICT_SIZE_BTYES
: The dictionary size per
column, in bytes.
The following column was added to the
performance_schema.rpd_nodes
table:
BASEREL_MEMORY_USAGE
: The base relation
memory footprint per node.
The rapid_query_stats
and
rpd_exec_stats
tables are now synchronized.
If a query record is removed from the
rapid_query_stats
table, it is also removed
from the rpd_exec_stats
table.
(WL #14759)