The following limitations apply to HeatWave AutoML. For HeatWave limitations, see: Section 2.17, “HeatWave Limitations”.
ML_TRAINroutine does not support MySQL user names that contain a period; for example, a user named
'joe.smith'@'cannot run the
ML_TRAINroutine. The model catalog schema created by the
ML_TRAINprocedure 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.
There is currently no way to monitor HeatWave AutoML query progress.
ML_TRAINis 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 specified
ML_TRAINparameters and options.
ML_PREDICT_TABLEare compute intensive processes, with
ML_EXPLAIN_TABLEbeing the most compute intensive. Limiting operations to batches of 10 to 100 rows by splitting large tables into smaller tables is recommended. MySQL 8.2.0 adds batch processing with the
batch_sizeoption. See: Section 3.14, “Progress tracking”.
ml_resultscolumn contains the prediction results and the data. This combination must be less than 65,532 characters.
HeatWave AutoML only supports datasets in the English language.
HeatWave AutoML does not support text columns with
HeatWave AutoML does not support a text target column.
HeatWave AutoML does not support recommendation tasks with a text column.
For the forecasting task,
endogenous_variablescannot be text.
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.