Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-mirror-table.html
For a given table, this value is computed based on its size, as well as the number and duration of queries accessing that table. The rpd_mirror table keeps track of all existing tables in the DB System, whose engine is InnoDB. MYSQL_ACCESS_COUNT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-select.html
SELECT [ALL | DISTINCT | DISTINCTROW ] [STRAIGHT_JOIN] [SQL_BUFFER_RESULT] select_expr [, select_expr] ... This helps reduce the intermediate result set sizes and identify data-related issues that might go unnoticed in MySQL. This topic provides ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
BOOL Enum None BOOL Fixed, Bytes Decimal TINYINT, SMALLINT, MEDIUMINT, INTEGER, INT, BIGINT Boolean None TINYINT, SMALLINT, MEDIUMINT, INTEGER, INT, BIGINT Int, Long None Attempts narrowing/widening conversion. Review the various file formats ...
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. Workload optimization ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model handle is generated or set by the user when the ML_TRAIN ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
The regression use-case is to predict house prices based on the size of the house, the address of the house, and the state the house is located in. In a real-life use case, you should prepare a larger amount of records for training and testing, and ... This topic describes how to prepare the data to use for a regression machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by default. If the routine cannot find a vector store, then it calls the ML_GENERATE routine and uses ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-28-u2.html
More data per node reduces costs by minimizing the size of the MySQL HeatWave Cluster required to store your data. MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave customers now have access to MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-billing.html
You are charged for the three MySQL instances according to their shapes, storage sizes as well as the data transfer between Availability Zones incurred by Group Replication.. Billing 12.10 Billing A high availability DB system contains three MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-restore-backup.html
The following limitations apply when restoring a backup of a high availability DB System: The data storage size of the high availability DB System cannot be reduced, but can be increased. Restoring a Backup of a High Availability DB System 12.7 ...