Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-load-model.html
You must load a machine learning model from the model catalog into MySQL HeatWave before running MySQL HeatWave AutoML routines other than ML_TRAIN. A model remains loaded and can be called repetitively by MySQL HeatWave AutoML routines until it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, use the batch_size option to limit operations to batches of 10 to 100 rows by splitting ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-quality.html
The metric you select to score the model must be compatible with the task type and the target data. mysql> SELECT @score; +--------------------+ | @score | +--------------------+ | 0.8888888955116272 | +--------------------+ 1 row in set (0.0409 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. Before You Begin Review how to Create a Machine Learning Model. Delete a Model To delete a model from the model catalog table: Query the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-monitoring.html
mysql> SELECT VARIABLE_NAME, VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE 'rapid_ml_status'; +-----------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------+----------------+ | ... You can ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
mysql> SELECT * FROM table_name LIMIT N; Replace table_name with your own table name, and N with the number of rows from the table you want to view. ML_PREDICT_TABLE generates predictions for an entire table of trained data. Depending on your MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
mysql> CREATE TABLE electricity_demand_train AS SELECT * FROM electricity_demand WHERE date < '2025-01-01'; Create the table to use for generating predictions. mysql> CREATE TABLE electricity_demand_test AS SELECT * FROM electricity_demand WHERE ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-predictions.html
If needed, you can also query all the columns from the table (SELECT * FROM regression_predictions) to review all the data at once. To generate predictions, use the sample data from the house_price_testing dataset. Even though the table has labels ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-score.html
mysql> SELECT @regression_score; +--------------------+ | @regression_score | +--------------------+ | 0.8438237905502319 | +--------------------+ 1 row in set (0.0453 sec) If done working with the model, unload it with the ML_MODEL_UNLOAD routine.
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-a-forecasting-model.html
mysql> SELECT @forecasting_score; +----------------------+ | @forecasting_score | +----------------------+ | -0.06810028851032257 | +----------------------+ 1 row in set (0.0429 sec) If done working with the model, unload it with the ML_MODEL_UNLOAD ... After generating predictions, you can score the model to assess its ...