Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-syntax.html
When a target schema is specified, Advisor generates recommendations for tables belonging to the target schema. Autopilot Indexing uses the following syntax: mysql> CALL sys.autopilot_index_advisor ([options]); options: { ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-search.html
When you enter a query, MySQL HeatWave GenAI performs a vector-based similarity search to retrieve similar content from the vector store and embedding tables available in the DB system. This helps the LLM to produce more relevant and accurate ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store.html
Using the inbuilt vector store and retrieval-augmented generation (RAG), you can load and query unstructured documents stored in Object Storage using natural language within the MySQL HeatWave ecosystem. The sections in this topic describe how to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
If you set use_secondary_engine=FORCED, the operation fails and generates an offload error. This topic describes how to run a SELECT query and insert the results into a target table using the INSERT ... The target table can be an InnoDB table and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental load. Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-joins.html
The plan evaluation limit prevents too much time being spent evaluating plans in cases where MySQL generates numerous plans that use the DUPSWEEDOUT semijoin strategy. Antijoins, with the exception of supported IN and EXISTS antijoin variants ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-manage-access.html
This native integration provides a unified data management platform for Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), machine learning, generative AI, and Lakehouse workloads. MySQL HeatWave is designed as a pluggable ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-modifying-tables.html
If you are explicitly trying to use the secondary engine, these queries generate an offload error. When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
If MySQL HeatWave execution is not possible for a query due to unsupported syntax or any other reason as mentioned in Diagnose Query Offload, the query is executed by the "DB System", and no errors are generated. Ensure that the following ...