8.1.5 The rpd_ml_stats Table

Note

The Performance Schema table described here is available as of MySQL 9.0.0. Support for MySQL HeatWave GenAI routines is available as of MySQL 9.0.1-u1.

The rpd_ml_stats table tracks the usage of successful MySQL HeatWave routines. These metrics reset whenever the respective DB system restarts.

The following MySQL HeatWave AutoML routines are tracked:

ML_TRAIN
ML_EXPLAIN
ML_PREDICT_ROW
ML_PREDICT_TABLE
ML_EXPLAIN_ROW
ML_EXPLAIN_TABLE

The following MySQL HeatWave GenAI routines are tracked:

ML_GENERATE
ML_EMBED_ROW

The rpd_ml_stats table has these columns:

STATUS_NAME
Identifies the type of meter tracking usage.
STATUS_VALUE
Displays metrics for metering. Content is displayed in JSON format.

Metrics in the table are entries as JSON values. The following metrics are used:

n_cells
The total number of table cells processed by the MySQL HeatWave AutoML routine for all invocations.
n_cells_user_excluded
The total number of table cells manually excluded for the MySQL HeatWave AutoML routine.
n_blob_cells
The total number of table BLOB cells processed by the MySQL HeatWave AutoML routine for all invocations.
table_size_bytes
The total number of bytes of data processed by the MySQL HeatWave AutoML routine for all invocations.
blob_size_bytes
The total number of bytes of BLOB/TEXT data processed by the MySQL HeatWave AutoML routine for all invocations.
model_size_bytes
The total number of bytes of data for the MySQL HeatWave AutoML model that is trained. This includes any explainer models. This metric only applies to the ML_TRAIN and ML_EXPLAIN MySQL HeatWave AutoML routines. All other routines will display NULL values.
input_size_bytes
The cumulative size in bytes of all input string/document invocations ingested by the MySQL HeatWave GenAI routine.
context_size_bytes
The size in bytes of the context string referenced when generating the response. This metric only applies to the ML_GENERATE MySQL HeatWave GenAI routine since the ML_EMBED_ROW routine does not have context. The metric will still appear for ML_EMBED_ROW, but will display a value of 0.
output_size_bytes
The cumulative size in bytes of responses generated by all invocations for the MySQL HeatWave GenAI routine.
n_invocations
The total number of times the routine has been successfully invoked on the MySQL HeatWave Cluster.
last_updated_timestamp
The POSIX timestamp of the last call.