5.3 HeatWave 机器学习监控_MySQL HeatWave 用户指南

MySQL HeatWave 用户指南 / 第 5 章 HeatWave 性能和监控 / 5.3 HeatWave 机器学习监控

5.3 HeatWave 机器学习监控

rapid_ml_status您可以通过查询变量或查询表的ML_STATUS列来监控 HeatWave ML 状态 performance_schema.rpd_nodes。

查询 rapid_ml_status变量：

该rapid_ml_status 变量提供 HeatWave ML 的状态。可能的值为 ON和OFF。

ON：HeatWave ML 已启动并正在运行。
OFF：HeatWave ML 已关闭。

可以 rapid_ml_status直接查询状态变量，也可以通过 performance_schema.global_status 表查询；例如：

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

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             |
+-----------------+----------------+

查询表的ML_STATUS列 performance_schema.rpd_nodes。

HeatWave 插件在每次 ML 查询后将 HeatWave ML 状态信息写入表的 ML_STATUS列。performance_schema.rpd_nodes可能的值包括：
- UNAVAIL_MLSTATE：HeatWave ML 不可用。
- AVAIL_MLSTATE: HeatWave ML 可用。
- DOWN_MLSTATE：HeatWave ML 已关闭。
ML_STATUS为每个 HeatWave 节点报告。

对于以下查询，从表中为每个 HeatWave 节点检索ID、 STATUS和： ML_STATUSperformance_schema.rpd_nodes
```
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 |
+----+---------------+---------------+
```

If rapid_ml_status is OFF or ML_STATUS reports DOWN_MLSTATE for any HeatWave node, you can restart the HeatWave Cluster in the Console but be aware that restarting interrupts any analytics queries that are running. See Starting, Stopping, or Restarting a HeatWave Cluster, in the MySQL Database Service Guide.