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 HeatWave AutoML is restarted by a HeatWave Cluster restart.
As of MySQL 8.1.0, a user can only load their own model, and
the user
parameter is ignored.
To share models with other users, see: Section 3.12.10, “Sharing Models”.
You can load multiple models but to avoid taking up too much space in memory, the number of loaded models should be limited to three.
mysql> CALL sys.ML_MODEL_LOAD(model_handle, user);
ML_MODEL_LOAD
parameters:
model_handle
: Specifies the model handle or a session variable containing the model handle. For how to look up a model handle, see Section 3.12.8, “Model Handles”.-
user
: The MySQL user name of the model owner. SpecifyNULL
if the model owner is the current user.As of MySQL 8.1.0, this parameter is ignored. It can be set to
NULL
.
-
An
ML_MODEL_LOAD
call withNULL
specified, indicating that the model belongs to the user executing theML_MODEL_LOAD
call:mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', NULL);
-
An
ML_MODEL_LOAD
call that specifies a session variable containing the model handle:mysql> CALL sys.ML_MODEL_LOAD(@iris_model, NULL);
-
Before MySQL 8.1.0, an
ML_MODEL_LOAD
call that specifies the model owner:mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', user1);