6.11 Monitor the Status of MySQL HeatWave AutoML

You can monitor the status of MySQL HeatWave AutoML by querying the rapid_ml_status variable or by querying the ML_STATUS column of the performance_schema.rpd_nodes table.

Before You Begin

• Review how to Track Progress for MySQL HeatWave AutoML Routines.

Query the rapid_ml_status Variable

The rapid_ml_status variable provides the status of MySQL HeatWave AutoML. Possible values are ON and OFF.

• ON: MySQL HeatWave AutoML is up and running.

• OFF: MySQL HeatWave AutoML is down.

The following example queries the rapid_ml_status status variable directly.

mysql> SHOW GLOBAL STATUS LIKE 'rapid_ml_status';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| rapid_ml_status | ON    |
+-----------------+-------+

The following example queries the the rapid_ml_status status through the performance_schema.global_status table.

mysql> SELECT VARIABLE_NAME, VARIABLE_VALUE
       FROM performance_schema.global_status
       WHERE VARIABLE_NAME LIKE 'rapid_ml_status';
+-----------------+----------------+
| VARIABLE_NAME   | VARIABLE_VALUE |
+-----------------+----------------+
| rapid_ml_status | ON             |
+-----------------+----------------+

Query the ML_STATUS Column

The MySQL HeatWave plugin writes MySQL HeatWave AutoML status information to the ML_STATUS column of the performance_schema.rpd_nodes table after each AutoML query. Possible values include:

• UNAVAIL_MLSTATE: MySQL HeatWave AutoML is not available.

• AVAIL_MLSTATE: MySQL HeatWave AutoML is available.

• DOWN_MLSTATE: MySQL HeatWave AutoML is down.

ML_STATUS is reported for each MySQL HeatWave node.

You can query the ML_STATUS column of the performance_schema.rpd_nodes table.

To following example retrieves ID, STATUS, and ML_STATUS for each MySQL HeatWave node from the performance_schema.rpd_nodes table:

mysql> SELECT ID, STATUS, ML_STATUS FROM performance_schema.rpd_nodes; 
+----+---------------+---------------+
| ID | STATUS        | ML_STATUS     |
+----+---------------+---------------+
|  1 | AVAIL_RNSTATE | AVAIL_MLSTATE |
|  0 | AVAIL_RNSTATE | AVAIL_MLSTATE |
+----+---------------+---------------+

Resolve a Down Status for MySQL HeatWave AutoML

If rapid_ml_status is OFF or ML_STATUS reports DOWN_MLSTATE for any MySQL HeatWave node, you can restart the MySQL HeatWave Cluster in the MySQL HeatWave Console. Be aware that restarting interrupts any analytics queries that are running.

See the following to learn more:

• Managing a MySQL HeatWave Cluster in the MySQL HeatWave on OCI Service Guide.

• Starting,Stopping, or Restarting a MySQL HeatWave Cluter in the MySQL HeatWave on AWS Service Guide.

• Restarting a Database in the MySQL HeatWave for Azure Service Guide.

What's Next

• Review Machine Learning Use Cases to create machine learning models with sample datasets.