Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
The time required to load a table into MySQL HeatWave depends on data size. You can monitor load progress by issuing the following query, which returns a percentage value indicating load progress. mysql> SELECT VARIABLE_VALUE FROM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
To view the MySQL HeatWave query history including query start time, end time, and wait time in the scheduling queue, as discussed in Section 5.4.10, “Auto Scheduling”. CONNECTION_ID The connection ID of the client that issued the query.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-row.html
ML_EXPLAIN_ROW explains predictions for one or more rows of unlabeled data. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-score.html
ML_SCORE scores a model by generating predictions using the feature columns in a labeled dataset as input and comparing the predictions to ground truth values in the target column of the labeled dataset. The dataset used with ML_SCORE should have ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON format. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing datasets. Two new tables in the same database are created with the following names: [original_table_name]_train ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-an-anomaly-detection-model.html
After preparing the data for an anomaly detection model, you can train the model. Requirements for Anomaly Detection Training Consider the following based on the type of anomaly detection you are running: Set the task parameter to anomaly_detection ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response for the given natural-language query. As of MySQL 9.4.1, the ML_GENERATE lets you generate text-based responses for queries ...