Table of Contents
- 5.1 Auto Shape Prediction
- 5.2 HeatWave Autopilot Report Table
- 5.3 HeatWave Monitoring
- 5.4 HeatWave AutoML Monitoring
- 5.5 HeatWave Performance Schema Tables
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 MySQL 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 MySQL HeatWave on AWS only.
MySQL 8.0.32 deprecates the
heatwave_load_report tables, and replaces them
heatwave_autopilot_report table in the
sys schema. A future release will remove them.
You can also monitor HeatWave from the console for your platform:
For HeatWave on OCI, the OCI Console uses MySQL Database Service Metrics. For more information, see MySQL Database Service Metrics.
If you are a MySQL HeatWave on AWS user, you can monitor HeatWave on the Performance page in the MySQL HeatWave Console.
For HeatWave in Oracle Database Service for Azure (ODSA), select Metrics on the details page for the HeatWave Cluster to access Microsoft Azure Application Insights.