The ML_MODEL_LOAD
routine loads a
model from the model catalog. A model remains loaded until the
model is unloaded using the
ML_MODEL_UNLOAD
routine or until
the MySQL HeatWave Cluster restarts.
MySQL 9.0.0 introduces support for large models that changes how
MySQL HeatWave AutoML stores models. See
Section 6.9.1, “The Model Catalog”.
ML_MODEL_LOAD
upgrades older
models.
Use ML_MODEL_ACTIVE
to check
which models are 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_LOAD
generates an error
if there are memory limitations.
Set the following parameters.
model_handle
: Specifies the model handle or a session variable containing the model handle. To look up a model handle, see Query the Model Handle.user
: The MySQL user name of the model owner. You can set this toNULL
. To learn how to share models with other users, see Share a Model.
-
An example that specifies the model handle and sets the
user
parameter toNULL
.mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', NULL);
-
An example that specifies a session variable containing the model handle.
mysql> CALL sys.ML_MODEL_LOAD(@iris_model, NULL);
-
An example that specifies the model handle and the model owner.
mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', user1);