Oracle Cloud Infrastructure Documentation

Database Management Metrics for MySQL HeatWave

You can use the Oracle Cloud Infrastructure Monitoring service to build metric queries to monitor Database Management-enabled MySQL HeatWave DB systems and create alarms to be notified when the metrics meet alarm-specified triggers.

Note

  • This section provides information on the DB system and HeatWave cluster metrics emitted by Database Management in the oracle_oci_database namespace. For information on the metrics emitted by the MySQL HeatWave service in the oci_mysql_database namespace, see MySQL HeatWave Service Metrics.
  • Database Management only emits metrics in the oracle_oci_database namespace for the primary MySQL instance in the DB system. For example, if Database Management is enabled for a DB system with secondary instances, it currently only emits metrics for the primary MySQL instance in the DB system and not for the other instances.

As initial steps, you must review the concepts essential to working with the Monitoring service and obtain the required permissions. For information, see Monitoring Concepts and Details for Monitoring.

Required Permissions

To monitor the metrics for DB systems, you must be granted the required type of access in a policy. The policy must grant you access to the monitoring services as well as the resources being monitored. If you try to perform an action and get a message that you do not have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which compartment you should work in. For more information on user authorizations for monitoring, see the Authentication and Authorization section for the related service: Monitoring or Notifications.

For information on the required Database Management permissions, see Permissions Required to Use Database Management.

For information on how to build metric queries and create alarms in the console or using API, see:

For information on data retention periods, see Storage Limits.