Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-active.html
Use this routine to check which models are loaded and active for which users. All active users and models share the amount of memory defined by the shape, and it might be necessary to schedule users. ML_MODEL_ACTIVE Syntax mysql> CALL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. To learn how to use ML_MODEL_IMPORT to share models, see Share a Model. ML_MODEL_IMPORT Overview ML_MODEL_IMPORT Syntax ML_MODEL_IMPORT Parameters Syntax ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-viewing.html
mysql> SELECT column FROM ML_SCHEMA_user name.MODEL_CATALOG where model_handle='model_handle'; The following example queries one of the model handles and views the model explanation for that model. To view the details for the models in your model ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-an-anomaly-detection-model.html
mysql> SELECT @anomaly_score; +--------------------+ | @anomaly_score | +--------------------+ | 0.6499999761581421 | +--------------------+ 1 row in set (0.0481 sec) If done working with the model, unload it with the ML_MODEL_UNLOAD routine. mysql> ... After generating predictions, you can score the model to assess its ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-row.html
This topic contains the following sections: ML_EMBED_ROW Syntax Syntax Examples See Also ML_EMBED_ROW Syntax mysql> SELECT sys.ML_EMBED_ROW('Text'[, options]); options: JSON_OBJECT(keyvalue[, keyvalue] ...) keyvalue: { 'model_id', {'ModelID'} ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
For example, the following query can now be offloaded to MySQL HeatWave for execution: SELECT DISTINCT a FROM t1 ORDER BY c DESC; (Bug #32583856) Query plan statistics are now collected and stored in a statistics cache when a query is executed in ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
All default MySQL configurations that are compatible with high availability are indicated as so in the MySQL Configuration Details, If you want to create a custom configuration that supports high availability, remember to select Support High ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-switchover-console.html
Do the following to switchover from the current primary instance to one of the secondary instances: In the MySQL HeatWave Console, select the Resources tab. In the Switchover to another Availability Zone panel Select the Preferred availability zone: ... Switchover Using the Console 12.5.1 Switchover Using the Console This task requires the following: A running DB system with high availability ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-privatelink-egress.html
Do the following to create an Egress PrivateLink: In the MySQL HeatWave Console, select the Resources tab. Select PrivateLink type: Select Egress and click Next to finish configuring the Egress PrivateLink on the next page: Configure external ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-privatelink-query.html
Do the following to create a Query PrivateLink: In the MySQL HeatWave Console, select the Resources tab. Select PrivateLink type: Select Query and click Next to provide the following information on the next page: Target DB System: Select the DB ...