Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
In the following example, Auto Encoding is run in recommend mode, which analyzes column data, checks the amount of memory on the MySQL node, and provides encoding recommendations intended to reduce the amount of space required on MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Autopilot Indexing can generate secondary index recommendations that optimize the overall workload performance. Autopilot Indexing obtains workloads from the statement digest history stored in the Performance Schema, evaluates them, and identifies ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Runtime data can be used for query optimization, troubleshooting, or to estimate the cost of running a particular query or workload on MySQL HeatWave. Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
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 ...