MySQL Database Service Metrics

MySQL Database Service metrics enable you to measure useful quantitative data about your MySQL DB system such as current connections, statement count, CPU utilization, and backup time. Use these metrics to create queries and alarms to monitor your resources.

Prerequisites

To view metrics using the Console, SDK, CLI, or Rest API, you should have access in a policy written by the administrator.

The policy should give you access to the monitoring services as well as the resources that you want to monitor. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you have been granted and the compartment you should work in.

See Authentication and Authorization section in Monitoring and Notifications.

Viewing Metrics for a Single DB System Using the Console

Use the Console to view MySQL Database Metrics of your DB system.

This task requires the following:
  • A policy that permits you access the monitoring services as well as the resources being monitored. See Prerequisites.
Do the following to view the metrics for your DB system:
  1. Open the navigation menu and click Databases. Under MySQL, click DB Systems.
  2. Choose the Compartment from the List Scope.
  3. Click the name of the DB system to open the DB System Details page.
  4. Under Resources, click Metrics.
The Metrics section displays a default set of charts for the current DB system.

Viewing Metrics for All DB Systems Using the Console

Use the Console to view MySQL Database Metrics of all DB systems present in a compartment.

This task requires the following:
  • A policy that permits you access the monitoring services as well as the resources being monitored. See Prerequisites.
Do the following to view the metrics for multiple DB systems:
  1. Open the navigation menu and click Observability & Management. Under Monitoring, click Service Metrics.
  2. Select your Compartment
  3. Under Metric namespace, select oci_mysql_database.
  4. (Optional) Filter the metrics using Dimensions. See To filter results and To select different resources.
The Service Metrics page displays a default set of charts for all DB systems in the selected compartment.

Metrics in oci_mysql_database

Use oci_mysql_database metrics namespace to monitor your resources and to diagnose and troubleshoot problems with your DB system. The metrics are automatically available for all DB systems you create. You need not enable monitoring on the resource to see these metrics.

Each metric includes the following dimensions:

  • resourceId: Specifies the OCID of the resource.
  • resourceName: Specifies the display name of the resource.
  • resourceType: (Optional) Specifies the node type emitting the metric, mysql or heatwave.
  • heatWaveNode: (Optional) Specifies the display name of the HeatWave node.
    Note

    Metric refers to the name used in SDK, CLI, or API, and Metric Display Name refers to the name used in the Console.

Table 13-1 MySQL Database Service Metrics

Metric Metric Display Name Unit Description Dimensions
CurrentConnections Current Connections count The number of current connections to the MySQL DB system.
  • resourceID
  • resourceName
ActiveConnections Active Connections count The number of connections actively executing statements against the MySQL DB system.
  • resourceID
  • resourceName
Statements Statement Count count The number of statements executed against the MySQL DB system.
  • resourceID
  • resourceName
StatementLatency Statement Latency ms Statement latency for all executed statements.
  • resourceID
  • resourceName
CPUUtilization CPU Utilization percent CPU utilization for the MySQL DB system host or HeatWave nodes.
  • resourceID
  • resourceName
  • heatWaveNode
  • resourceType
MemoryUtilization Memory Utilization percent Memory utilization for the MySQL DB system host or HeatWave nodes.
  • resourceID
  • resourceName
  • heatWaveNode
  • resourceType
NetworkReceiveBytes Network Receive Bytes bytes Network receive bytes for the MySQL DB system.
  • resourceID
  • resourceName
  • heatWaveNode
  • resourceType
NetworkTransmitBytes Network Transmit Bytes bytes Network transmit bytes for the MySQL DB system.
  • resourceID
  • resourceName
  • heatWaveNode
  • resourceType
DbVolumeReadOperations Disk Read Operations count The total number of read operations for the DB volume(s).
  • resourceID
  • resourceName
  • resourceType
DbVolumeWriteOperations Disk Write Operations count The total number of write operations for the MySQL DB volume(s).
  • resourceID
  • resourceName
  • resourceType
DbVolumeReadBytes Disk Read Bytes bytes The total bytes read from the MySQL DB system volume(s).
  • resourceID
  • resourceName
  • resourceType
DbVolumeWriteBytes Disk Write Bytes bytes The total bytes written to the MySQL DB system volume(s).
  • resourceID
  • resourceName
  • resourceType
DbVolumeUtilization Disk Space Utilization percent The total space utilization of the MySQL DB system volume(s).
  • resourceID
  • resourceName
HeatWaveHealth HeatWave Health Status status HeatWave health status. One of the following values:
  • 0: Healthy
  • 0.5: Reloading data
  • 1: Recovering
  • 2: Failed
See HeatWave Cluster Failure and Recovery Overview.
  • resourceID
  • resourceName
HeatWaveStatements HeatWave Statement Count count The number of statements executed against the MySQL DB System and were executed on HeatWave.
  • resourceID
  • resourceName
HeatWaveDataLoadProgress HeatWave Data Load Progress percent Progress of data load into HeatWave memory.
  • resourceID
  • resourceName
BackupSize Total Backup Size bytes The aggregate size of all backups per DB system.
  • resourceID
  • resourceName
  • dbSystemId
  • compartmentId
BackupTime Backup Time ms The time taken for a backup operation.
  • resourceID
  • resourceName
  • dbSystemId
  • compartmentId
ChannelLag Inbound Channel Lag ms The channel lag, with respect to the source, observed over the last interval.
  • resourceID
  • resourceName
ChannelFailure Inbound Channel Failure ms The channel failure events observed over the last interval.
  • resourceID
  • resourceName

Queries and Alarms

Use MySQL Database Service metrics to monitor your resources by creating queries and alarms.

  • Queries: Create queries for metrics in the oci_mysql_database namespace to actively monitor your resources. See Building Metric Queries.
  • Alarms: Create alarms for metrics in the oci_mysql_database namespace to passively monitors your resources and notify you when metrics meet alarm-specified triggers. See Managing Alarms.

For example, you can use DbVolumeUtilization metric in the oci_mysql_database namespace to create a query to actively monitor the space utilization of the DB system or create an alarm to get notifications when the DbVolumeUtilization metric meets the alarm-specified triggers.