Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
This automated, self-managing storage layer scales to the size required for your MySQL HeatWave Cluster and operates independently in the background. MySQL HeatWave is a fully-managed cloud service that enables organizations to efficiently run ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
memory_gain_ascending: Whether to rank the unload table suggestions in ascending or descending order based on the table size. Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-requirements.html
To use MySQL HeatWave GenAI, you need the following: A MySQL HeatWave DB system that meets the following requirements: The MySQL HeatWave DB system must be version 9.0.0 - Innovation or higher. For more information, see Creating a DB system and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
The number of output files and size of individual files depends on the amount of data generated by the query. Exported query results are in CSV, Parquet, or JSON (As of MySQL 9.3.1) format. The names for the output files are auto-generated and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-json.html
Note The JSON size is measured after Lakehouse extracts and converts JSON data to JSON DOM representation internally. MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 bytes ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
For each table that is loaded in MySQL HeatWave, the default heap segment size is 64KB per table, and this is allocated from the root heap. MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
The time required to load a table into MySQL HeatWave depends on data size. You can monitor load progress by issuing the following query, which returns a percentage value indicating load progress. mysql> SELECT VARIABLE_VALUE FROM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd_vector_indexes-table.html
The rpd_vector_indexes table provides information about vector indexes created for different vector store or embedding tables. SPACE: Vector distance metric, which can be one of: DOT, EUCLIDEAN, and COSINE. Queries using the same distance metric ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-columns-table.html
The rpd_columns table provides column encoding information for columns of tables loaded in MySQL HeatWave. The rpd_columns table has these columns: TABLE_ID A unique identifier for the table. DATA_PLACEMENT_INDEX The data placement key index ID ...