6.1.3 The rpd_ml_stats Table

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

The following AutoML routines are tracked:

• ML_TRAIN

• ML_EXPLAIN

• ML_PREDICT_ROW

• ML_PREDICT_TABLE

• ML_EXPLAIN_ROW

• ML_EXPLAIN_TABLE

The following 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 AutoML routine for all invocations.

• n_cells_user_excluded

  The total number of table cells manually excluded for the AutoML routine.

• n_blob_cells

  The total number of table BLOB cells processed by the AutoML routine for all invocations.

• table_size_bytes

  The total number of bytes of data processed by the AutoML routine for all invocations.

• blob_size_bytes

  The total number of bytes of BLOB/TEXT data processed by the AutoML routine for all invocations.

• model_size_bytes

  The total number of bytes of data for the AutoML model that is trained. This includes any explainer models. This metric only applies to the ML_TRAIN and ML_EXPLAIN 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 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 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 GenAI routine.

• n_invocations

  The total number of times the routine has been successfully invoked on the MySQL AI Engine.

• last_updated_timestamp

  The POSIX timestamp of the last call.