You can monitor the status and performance of your fleet of MySQL HeatWave DB systems and attached HeatWave clusters, if any, on the MySQL HeatWave fleet summary page.

Database Management provides a unified view of the DB systems for which Database Management is enabled in a compartment, on the MySQL HeatWave fleet summary page. This enables you to monitor your fleet of DB systems and attached HeatWave clusters, if any, by various dimensions on a single page and respond to Oracle Cloud Infrastructure Monitoring service alarms.

Before you go to the MySQL HeatWave fleet summary page to monitor the fleet of DB systems and HeatWave clusters, you must complete the tasks given in Get Started. Note that to view metrics and alarms, you must have additional Monitoring service permissions. For information, see Additional Permissions Required to Use Database Management.

To go to the MySQL HeatWave fleet summary page:

1. Sign in to the Oracle Cloud Infrastructure console.
2. Open the navigation menu, click Observability & Management. Under Database Management, click Diagnostics & Management and then click MySQL HeatWave.

   The MySQL HeatWave fleet summary page is displayed.

3. On the left pane, select the Compartment in which your DB systems reside.
4. Select a time period in the Time period drop-down list in the upper-right corner of the page. The options are Last 60 min (default option), Last 24 hours, and Last 7 days.

The MySQL HeatWave fleet summary page has the following tabs:

• MySQL databases: The MySQL databases tab is displayed by default. When viewing the information on this tab, you can use the following filters on the left pane to filter the DB systems:
  • Monitoring status: Select an option to filter DB systems by monitoring status.
  • Version: Select an option to filter DB systems by version.
  • HeatWave: Select an option to filter DB systems based on whether HeatWave is enabled.

  The following tiles on the MySQL databases tab display important status and performance information about your DB systems for the selected time period:

  • Inventory: Displays an overview of the DB systems in the compartment. You can use the options in the drop-down list on this tile to categorize and view DB systems in a donut chart:
    • Version: Select this option to categorize DB systems by version.
    • HeatWave: Select this option to categorize DB systems based on whether HeatWave is enabled or not.
  • Monitoring status: Displays the current monitoring status of the DB systems in a donut chart. The monitoring status indicates whether Database Management can collect monitoring metrics for the DB systems.
  • Resource usage: Displays a summary of the overall CPU, Storage, and Memory allocation and usage. You can hover the mouse on the charts to view utilization details.
  • Alarms: Displays the total number of open DB system alarms in the compartment, and the number of alarms by severity. If the DB systems have attached HeatWave clusters, then the alarms include those created to monitor HeatWave cluster metrics. Note that the alarms are only displayed in Database Management if the OCID of the DB system is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For more information, see Monitor Alarms for MySQL HeatWave DB Systems.

  Below the tiles, the list of DB systems for which Database Management is enabled is displayed along with the following information:

  • DB system name: Name of the DB system.
  • Monitoring status: Monitoring status of the DB system.
  • HeatWave: HeatWave enablement status. Indicates whether a HeatWave cluster is attached to the DB system.
  • HeatWave nodes: Number of HeatWave nodes in the HeatWave cluster.
  • Average statements: Average number of SQL statements executed per minute.
  • Average statement latency: Average latency (in milliseconds) for the executed SQL statements.
  • CPU utilization: Percentage of CPU utilized by the DB system.
  • Storage utilization: Percentage of storage utilized by the DB system.
  • Memory utilization: Percentage of memory utilized by the DB system.
• HeatWave clusters: The HeatWave clusters tab displays information about the HeatWave clusters attached to the DB systems. When viewing the information on this tab, you can use the following filters on the left pane:
  • Monitoring status: Select an option to filter HeatWave clusters by monitoring status.
  • Shape: Select an option to filter HeatWave clusters by shape.
  • Lakehouse: Select an option to filter HeatWave clusters based on whether Lakehouse is enabled.

  The following tiles on the HeatWave clusters tab display important status and performance information about the HeatWave clusters attached to the DB systems, for the selected time period:

  • Inventory: Displays an overview of the HeatWave clusters in the compartment. You can use the options in the drop-down list on this tile to categorize and view HeatWave clusters in a donut chart:
    • Shape: Select this option to categorize HeatWave clusters by shape.
    • Lakehouse: Select this option to categorize HeatWave clusters based on whether Lakehouse is enabled or not.
  • Monitoring status: Displays the current monitoring status of the HeatWave clusters in a donut chart:
    • Up: HeatWave cluster health status is healthy, reloading, or recovering.
    • Down: HeatWave cluster health status is failed. This status is displayed if even one of the nodes in the HeatWave cluster is in a failed state.
    • Unknown: HeatWave cluster health status metric is unavailable.
  • Resource usage: Displays a summary of the overall Memory allocation and usage and CPU utilization. You can hover the mouse on the Memory chart to view utilization details.
  • Alarms: Displays the total number of open alarms for DB systems with attached HeatWave clusters in the compartment, and the number of alarms by severity. This includes alarms created to monitor HeatWave cluster metrics. Note that the alarms are only displayed in Database Management if the OCID of the DB system is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For more information, see Monitor Alarms for MySQL HeatWave DB Systems.

  Below the tiles, the following additional information about the HeatWave clusters attached DB systems in the fleet is displayed:

  • Cluster DB system name: Name of the DB system to which the HeatWave cluster is attached.
  • Monitoring status: Current monitoring status of the HeatWave clusters:
    • Up: HeatWave cluster health status is healthy, reloading, or recovering.
    • Down: HeatWave cluster health status is failed. This status is displayed if even one of the nodes in the HeatWave cluster is in a failed state.
    • Unknown: HeatWave cluster health status metric is unavailable.
  • Nodes: Number of HeatWave nodes in the HeatWave cluster.
  • Lakehouse: Lakehouse enablement status. Indicates whether Lakehouse is enabled for the HeatWave cluster.
  • Memory utilization: Percentage of memory utilized by the nodes in the HeatWave cluster.
  • CPU utilization: Percentage of CPU utilized by the nodes in the HeatWave cluster.