HeatWave User Guide  /  ...  /  ML_MODEL_UNLOAD

10.2.11 ML_MODEL_UNLOAD

ML_MODEL_UNLOAD unloads a model from MySQL HeatWave AutoML.

As of MySQL 9.0.0, ML_MODEL_UNLOAD does not check whether the model specified is in the model catalog. If it is not, ML_MODEL_UNLOAD will succeed, but will not unload any model. Use ML_MODEL_ACTIVE to check which models are active and owned by the user.

ML_MODEL_UNLOAD Syntax

mysql> CALL sys.ML_MODEL_UNLOAD(model_handle);

To run ML_MODEL_UNLOAD, define the model_handle. To look up a model handle, see Query the Model Handle.

Syntax Examples

  • An example that specifies the model handle.

    mysql> CALL sys.ML_MODEL_UNLOAD('ml_data.iris_train_user1_1636729526');
  • An example that specifies a session variable containing the model handle.

    mysql> CALL sys.ML_MODEL_UNLOAD(@iris_model);

See Also