Chapter 7 HeatWave Performance and Monitoring

Table of Contents

7.1 HeatWave Autopilot Report Table

7.2 HeatWave MySQL Monitoring

7.2.1 HeatWave Node Status Monitoring

7.2.2 HeatWave Memory Usage Monitoring

7.2.3 Data Load Progress and Status Monitoring

7.2.4 Change Propagation Monitoring

7.2.5 Query Execution Monitoring

7.2.6 Query History and Statistics Monitoring

7.2.7 Scanned Data Monitoring

7.3 HeatWave AutoML Monitoring

7.4 HeatWave Performance Schema Tables

7.4.1 The rpd_column_id Table

7.4.2 The rpd_columns Table

7.4.3 The rpd_exec_stats Table

7.4.4 The rpd_nodes Table

7.4.5 The rpd_preload_stats Table

7.4.6 The rpd_query_stats Table

7.4.7 The rpd_table_id Table

7.4.8 The rpd_tables Table

The MySQL Performance Schema collects statistics on the usage of HeatWave. Use SQL queries to access this data and check the system status and performance.

As of MySQL 8.0.31, the Auto Shape Prediction feature in HeatWave Autopilot uses MySQL statistics for the workload to assess the suitability of the current shape. Auto Shape Prediction provides prompts to upsize the shape and improve system performance, or to downsize the shape if the system is under-utilized. This feature is available for HeatWave on AWS only.

MySQL 8.0.32 deprecates the heatwave_advisor_report and heatwave_load_report tables, and replaces them with the heatwave_autopilot_report table in the sys schema. A future release will remove them.

Monitor HeatWave from the HeatWave Console:

• For HeatWave on OCI, the HeatWave Console uses Metrics. See Metrics in the HeatWave on OCI Service Guide.

• HeatWave on AWS users can monitor HeatWave on the Performance page in the HeatWave Console.

• For HeatWave for Azure, select Metrics on the details page for the HeatWave Cluster to access Microsoft Azure Application Insights.