Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-dynamic-query-offload.html
As of MySQL 9.0.0, MySQL HeatWave uses dynamic query offload to choose the optimal execution engine for queries based on query and execution engine characteristics, which achieves improved performance. The overhead for more complex queries is also ... Before MySQL 9.0.0, MySQL HeatWave uses a query cost threshold to choose either INNODB or MySQL HeatWave as the execution engine for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
This topic describes how to encode string columns to improve the performance of queries that access them. This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encryption-compression-functions.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Table 5.6 Encryption and Compression Functions Name Description ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-flow-control-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
All the elements that are necessary to use MySQL HeatWave GenAI with proprietary data are integrated and optimized to work with each other. MySQL HeatWave GenAI is a feature of MySQL HeatWave that lets you communicate with unstructured data in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
When you run MySQL HeatWave Chat, it automatically loads the default LLM. By default, MySQL HeatWave Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
The service is optimized for Amazon Web Services (AWS) and offers unmatched performance and price-performance. As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate text summaries for unstructured files available in Object Storage. You need to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-group-by-modifiers.html
In the MySQL HeatWave secondary engine, the GROUP BY clause permits the following modifiers: A CUBE modifier in addition to the WITH ROLLUP modifier. (Available in MySQL HeatWave only.) A ROLLUP modifier as a preferred alternative to the WITH ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Table 5.7 JSON Functions Name Description -> Return value from ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
Lakehouse Auto Parallel Load, which extends the Auto Parallel Load feature of MySQL HeatWave, facilitates the process of loading data from Object Storage into MySQL HeatWave by automating many of the steps involved, including: Excluding schemas, ...