HeatWave AutoML has the following limitations:
The
ML_TRAIN
routine does not support MySQL user names that contain a period; for example, a user named'joe.smith'@'
cannot run the%
'ML_TRAIN
routine. The model catalog schema created by theML_TRAIN
procedure incorporates the user name in the schema name (e.g.,ML_SCHEMA_joesmith
), and a period is not a permitted schema name character.The table used to train a model (the training dataset) cannot exceed 10 GB, 100 million rows, or 1017 columns. Before MySQL 8.0.29, the column limit was 900.
To avoid taking up too much space in memory, the number of loaded models should be limited to three.
“Bring your own model” is not supported. Use of non-HeatWave AutoML models or manually modified HeatWave AutoML models can cause undefined behavior.
Models greater than 900 MB in size are not supported. If a model being trained by the
ML_TRAIN
routine exceeds 900 MB, theML_TRAIN
query fails with an error.-
There is currently no way to monitor HeatWave AutoML query progress.
ML_TRAIN
is typically the most time consuming routine. The time required to train a model depends on the number of rows and columns in the dataset and the specifiedML_TRAIN
parameters and options.ML_EXPLAIN_TABLE
andML_PREDICT_TABLE
are compute intensive processes, withML_EXPLAIN_TABLE
being the most compute intensive. Limiting operations to batches of 10 to 100 rows by splitting large tables into smaller tables is recommended. Ctrl+C
interruption is supported only forML_TRAIN
,ML_EXPLAIN_ROW
, andML_EXPLAIN_TABLE
.ML_EXPLAIN_*
routines limit explanations to the 100 most relevant features.Concurrent HeatWave analytics and HeatWave AutoML queries are not supported. A HeatWave AutoML query must wait for HeatWave analytics queries to finish, and vice versa. HeatWave analytics queries are given priority over HeatWave AutoML queries.
MySQL HeatWave on AWS only supports HeatWave AutoML with the HeatWave.256GB node shape. To use HeatWave machine learning functionality, select that shape when creating a HeatWave Cluster.