Search Results
https://dev.mysql.com/doc/heatwave/en/index.html
It covers how to load data from the DB System and Object Storage, accelerate query processing, optimize workloads, and use the machine learning and generative AI features of MySQL HeatWave. For information about creating and managing a MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-syntax.html
Only run Advisor on multiple schemas if the queries access tables in multiple schemas. Autopilot Indexing uses the following syntax: mysql> CALL sys.autopilot_index_advisor ([options]); options: { JSON_OBJECT('key','value'[,'key','value'] ...) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor.html
The MySQL HeatWave Autopilot improves MySQL database performance without manual tuning. It uses machine learning to study how the database is used and automatically recommends or applies optimizations such as indexing and data compression. This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ON. Check if you ...
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-auto-parallel-load-syntax.html
This adds an include list to exactly specify the tables and columns to load for a set of queries. MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using ...
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-comparison-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 . The VARLEN Support column identifies functions and operators ...
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-dictionary-encoding.html
Queries that use string operators on dictionary-encoded string columns are not offloaded. Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality ...