Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Specifying fewer combinations generates recommendations more quickly but recommendations may not be optimal. Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor.html
It uses machine learning to study how the database is used and automatically recommends or applies optimizations such as indexing and data compression. The MySQL HeatWave Autopilot improves MySQL database performance without manual tuning. This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-arithmetic-operators.html
All arithmetic operators are supported with variable-length encoded string columns, see Section 5.8.1.4, “Encoding String Columns”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.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 . CAST() from and to all the MySQL HeatWave supported numeric, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-masking-deindentification-functions.html
The following table shows data masking and de-identification functions supported by MySQL HeatWave.
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 ...