Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. Verify if the query is offloaded to MySQL HeatWave for processing. mysql> CREATE MATERIALIZED VIEW airport_US AS SELECT airport.* FROM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table is offloaded and loaded into the MySQL HeatWave Cluster Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ... To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. Execute EXPLAIN Statement Before running a query, you can use EXPLAIN to ...To ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. Loading Partitions using Secondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated processing. Verify if the query is offloaded to MySQL HeatWave for processing. To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain.html
MySQL 9.0.0 introduces support for large models that changes how MySQL HeatWave AutoML stores models. For example: mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', NULL); See Load a Model and Work with Model Handles to learn more. mysql> CALL sys.ML_EXPLAIN('bank_marketing_test.bank_train', 'y', @bank_test, NULL); The following example trains the Fast SHAP model explainer and SHAP prediction ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-active.html
ML_MODEL_ACTIVE Syntax mysql> CALL sys.ML_MODEL_ACTIVE (user, model_info); ML_MODEL_ACTIVE parameters: user: The user to provide information for. Use this routine to check which models are loaded and active for which users. All active users and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training.html
Topic Modeling: Generate words and similar expressions that best characterize a set of documents (As of MySQL 9.0.1-u1). MySQL HeatWave AutoML supports tables up to 10 GB in size with a maximum of 100 million rows and or 1017 columns. mysql> SET ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-limitations.html
You can access the MySQL instance that functions as the primary instance only. You cannot access the other two secondary instances directly using MySQL Shell or any other clients. MySQL HeatWave Clusters, as well as any features that require a MySQL ... Limitations for High Availability 12.9 Limitations for High Availability A high availability DB system has certain ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-connecting.html
Connecting to a DB System 5 Connecting to a DB System Clients and applications interact with a MySQL HeatWave Cluster by connecting to the DB System. This chapter describes how to connect to the DB System from the MySQL HeatWave Console and from ...