MySQL HeatWave User Guide  /  ...  /  HeatWave Memory Usage Monitoring

6.2.2 HeatWave Memory Usage Monitoring

To view the memory usage for each HeatWave node:

mysql> SELECT ID, MEMORY_USAGE, MEMORY_TOTAL, BASEREL_MEMORY_USAGE 
          FROM performance_schema.rpd_nodes;
+----+--------------+--------------+----------------------+
| ID | MEMORY_USAGE | MEMORY_TOTAL | BASEREL_MEMORY_USAGE |
+----+--------------+--------------+----------------------+
|  0 |    115760258 | 515396075520 |            115760152 |
|  1 |    115845086 | 515396075520 |            115844980 |
+----+--------------+--------------+----------------------+

For column descriptions, see Section 6.4.4, “The rpd_nodes Table”.