Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
rapid_compression System Variable rapid_compression Scope Session Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value AUTO Valid Values ON OFF Whether to enable or disable data compression before loading data into MySQL HeatWave. The ...Most MySQL HeatWave variable settings are managed by OCI and cannot be modified ...
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-pre-authenticated-requests.html
What's Next Learn how to load structured data using Lakehouse Auto Parallel Load. To review the syntax for loading structured data using Lakehouse Auto Parallel Load, see Auto Parallel Load Syntax and Lakehouse External Table Syntax.
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
To set the embedding model for all VECTOR columns in the table, load the data using Lakehouse Auto Parallel Load and set the dialect parameter embed_model_id accordingly. Learn how to load structured data using Lakehouse Auto Parallel Load or ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-uniform-resource-identifiers.html
What's Next Learn how to load structured data using Lakehouse Auto Parallel Load. To review the syntax for loading structured data using Lakehouse Auto Parallel Load, see Auto Parallel Load Syntax and Lakehouse External Table Syntax. As of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Apply these optimizations manually, or use MySQL HeatWave Autopilot Advisor, which includes the following: Auto Encoding recommends string column encodings that minimize the required cluster size and improve query performance. Auto Data Placement ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-4-0.html
Auto Parallel Load now has a validation mode to validate files before loading them. (WL #16098) MySQL HeatWave Auto Parallel Load and Auto Unload now support a table inclusion list, as well as a table exclusion list. MySQL HeatWave Lakehouse ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-1-0.html
(WL #16414) MySQL HeatWave Auto Parallel Load now uses Autopilot to collect statistics about frequently used InnoDB and MySQL HeatWave tables. Auto Parallel Load then automatically loads these tables to MySQL HeatWave. If a manually loaded table ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-console.html
Autopilot Shape Advisor with MySQL HeatWave Console 17.3.1 Autopilot Shape Advisor with MySQL HeatWave Console To view the Autopilot Shape Advisor: Connect to the DB System of interest. It shows the Auto Shape Prediction data for the DB System. For ...In the MySQL HeatWave Console, click the Workspace tab, and then click the Shape Advisor ...